CLB
04-14-2010, 12:27 PM
I need some help to get my data rearranged in my sheet.
My spreadsheet contains Item Numbers and Customer Data. Column C to ? contains Customer specific information..Location...etc..
Col A Col B Col C:?
Item # Customer Customer Specific information.
123 ABC Could be C:D or C:JJ
123 DEF
123 GHI
456 ABC
456 DEF
I would like to rearrange the data to the following columns:
Col A Col B
123
ABC Customer Specific info. C:?
DEF
GHI
456
ABC
DEF
One Item number could have 1 Customer or could have 1000 Customers.
Many thanks in advance.
My spreadsheet contains Item Numbers and Customer Data. Column C to ? contains Customer specific information..Location...etc..
Col A Col B Col C:?
Item # Customer Customer Specific information.
123 ABC Could be C:D or C:JJ
123 DEF
123 GHI
456 ABC
456 DEF
I would like to rearrange the data to the following columns:
Col A Col B
123
ABC Customer Specific info. C:?
DEF
GHI
456
ABC
DEF
One Item number could have 1 Customer or could have 1000 Customers.
Many thanks in advance.