Forum Discussion
Unpivot Multiple Coumns
I am trying to unpivot a table in a certain way, and it's making my brain hurt.
I think it's easiest if I show you the table, and then show you what I want it to look like:
Current Table:
- Project Name
- Owner
- 'Status - January' (through to December, so 12 columns)
- 'Budget - January' (through to December, so 12 columns)
I need my final table to essentially collapse each of the data types that have 12 columns, so my final table looks like this:
- Project Name
- Owner
- Month
- Status
- Budget
Any ideas on how I do this? I'm fine Un-pivoting one set of columns, but two I don't know how to do
Thanks
Hi shaunguyver
I am attaching a sample Excel file.
See if it is useful
Basically steps
1) Unpivot 24 columns (Status-Month & Budget-Month)
2)Split attribute by "-"
3) Pivot the column to get Status and Budget as columns
1 Reply
- Zubair_MuhammadCommunity Champion
Hi shaunguyver
I am attaching a sample Excel file.
See if it is useful
Basically steps
1) Unpivot 24 columns (Status-Month & Budget-Month)
2)Split attribute by "-"
3) Pivot the column to get Status and Budget as columns