QUERY

[LELOA]

spreadsheet which has the following columns.
customer pn vendor number vendor Plus many more
UNIQUE mANY MANY

What i need to do is creat a query to have column a show only customer part number once and move the corresponding vendor part number to the right of the last column used

customer pn MFG Vendor Part No Unit Price
011036608MXY KOA RK73H2BTTD2000F
011005068MXS KOA RK73H1JLTD49R9F
011005068MXS KOA RK73H1JTD49R9F
011036106MXS KOA RK73B1ELTP101J
407585173LRS KOA RK73H1JLTD1052F



customer pn mfg Vendor Part No Unit Price Vendor PN No
011036608MXY KOA RK73H2BTTD2000F
011005068MXS KOA RK73H1JLTD49R9F RK73H1JTD49R9F
011036106MXS KOA RK73B1ELTP101J
407585173LRS KOA RK73H1JLTD1052F

This makes the spreadsheet from 5 rows to 4...

I have approx. 68000 rows of information on a number of spreadsheets and need to bring them into one

tks
lee

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886