Forum Discussion
jeggen
Helper II
Helper IIUnpivot data and combine by year
This seems like it should be simple but can't figure it out. I need to unpivot my data from this: Customer ID Year 1 Revenue Year 1 Category Year 2 Revenue Year 2 Category Year 3 Revenue...
You won't get that 'intermediate' table.
Unpivot everything apart from Customer ID.
Split the Attribute column so that you get a column with only 'Revenue' or 'Category' in it.
Pivot that column with the Value as Values. Use "Don't Aggregate"
That should be it.
Let me know.
jeggenHelper II
Helper IIWorked perfectly, thank you!