Unpivot data into multiple columns

[Anonymous]

Hello,

I have a data set with the following structure (columns)

Attribute  SalesYear1 SalesYear1 SalesYear1  CostYear1 CostYear2 CostYear3

I would like to transform this into the following structure (columns)

Attribute Year Sales Costs

I think it would be staright forward without the cost column. However, I don't know how to unpiviot into more than two rows.

Thank you in advance for any help

[HotChilli]

Can you provide some sample data please

[Anonymous]

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)

[HotChilli · Accepted solution]

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.

[Anonymous]

This worked out! Thank you for your time & effort to look into this! I appreciate your help!