Unpivot Multiple Coumns

[shaunguyver]

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

[Zubair_Muhammad · Accepted solution]

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