A
Allan
I've search for a week now and can't seem to find an answer.
I have a spreadsheet that contains about 150 columns with row 1 being an
account number and rows 2..n contain products purchased. Example:
10 20
apples cans
oranges boxes
grapes
Some clients may have only 1 product while another client may have 300.
How can I transpose the data into rows and maintain the account number with
the item? Example:
10 apples
10 oranges
10 grapes
20 cans
20 boxes
Any help would be appreciated.
Thanks,
Allan
I have a spreadsheet that contains about 150 columns with row 1 being an
account number and rows 2..n contain products purchased. Example:
10 20
apples cans
oranges boxes
grapes
Some clients may have only 1 product while another client may have 300.
How can I transpose the data into rows and maintain the account number with
the item? Example:
10 apples
10 oranges
10 grapes
20 cans
20 boxes
Any help would be appreciated.
Thanks,
Allan