How can I transform my data?
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