r/excel•
question89

How can I transform my data?

unsolved

my table is set up as such http://imgur.com/a/rOXJr

I have the customer ID in the first column. and the next 95 columns are for a product and its associated revenue.

I want my data to be set up:

Customer, Product Name, Revenue

so 3 columns.

is there a quick way to pivot this or will i have to copy and past 96 times?

Posted Apr 26, 2017, 6:04 PM UTC

36
Loading comments…