cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shaunguyver Member
Member

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 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Unpivot Multiple Coumns

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 1
Super User
Super User

Re: Unpivot Multiple Coumns

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