Forum Discussion

shaunguyver's avatar
shaunguyver
Helper III
7 years ago
Solved

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

1 Reply