Transform Data from Excel

[Manuel123]

Dear all,

I hope you can help me with my current problem. I have date in the following format:

Date	30.06.2021	31.07.2021	31.08.2021
ValueDescription 1	1	2	3
ValueDescription 2	4	5	6

What would be the best way to get a table lik the following:

Date	ValueDescription	Value
30.06.2021	ValueDescription1	1
31.07.2021	ValueDescription1	2
31.08.2021	ValueDescription1	3
30.06.2021	ValueDescription2	4
31.07.2021	ValueDescription2	5
31.08.2021	ValueDescription2	6

I hope you can help me.

Best regards

Manuel

[BA_Pete · Accepted solution]

Hi @Manuel123 ,

In Power Query, select your [Date] column, go to the transform tab and select the dropdown arrow next to 'Unpivot Columns', select 'Unpivot Other Columns', then rename your columns to whatever you want them to be.

Pete

[Manuel123]

Dear @BA_Pete,

thank you for your quick reply. Works like a charm.

BR
Manuel