Forum Discussion
Unpivot data into multiple columns
Duplicate the query.
In one, unpivot the Sales columns and remove the cost columns.
In the other, unpivot the Costs and remove the sales columns.
In each query, alter the data so you have Year in a column by itself
'Merge as New' the two queries on Year and Division (Inner Join).
Expand and tidy as appropriate.
This is an example: I can unpivot the three sales columns into two columns (year & sales Value). However; iwould like to have three columns (year, sales value & cost value)
Duplicate the query.
In one, unpivot the Sales columns and remove the cost columns.
In the other, unpivot the Costs and remove the sales columns.
In each query, alter the data so you have Year in a column by itself
'Merge as New' the two queries on Year and Division (Inner Join).
Expand and tidy as appropriate.
This worked out! Thank you for your time & effort to look into this! I appreciate your help!