Transform imported table

[GeraldinneG]

Hello everyone,

Please, I need help with this trouble.

I imported a table from a web site and I need to change the structure table.

Original table

Day	Jan	Feb	Mar
1	850	855	875
2	851	854	870
3	852	856	869
4	850	860	871

Result

Day	Month	USD
1	Jan	850
2	Jan	851
3	Jan	852
4	Jan	850
1	Feb	855
2	Feb	854
3	Feb	856

Is it posible to do?

Thanks!

[wdx223_Daniel]

NewStep=Table.UnpivotOtherColumns(PreviousStepName,{"Day"},"Month","USD")

[otravers · Accepted solution]

Select and unpivot the Jan-March columns:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...