Forum Discussion
How to get all columns per row
Hi i have the next database
I want to transform the data to achieve this:
Any idea on how to do it?
Hi Anonymous ,
In Power Query, select your [Nombre] column, go to Transform tab > Unpivot columns (dropown) > Unpivot Other Columns.
In the formula bar you will see code like this:
You can change Attribute/Value to Fecha/Importe by changing the underlined parts above.
Pete
2 Replies
Hi Anonymous ,
In Power Query, select your [Nombre] column, go to Transform tab > Unpivot columns (dropown) > Unpivot Other Columns.
In the formula bar you will see code like this:
You can change Attribute/Value to Fecha/Importe by changing the underlined parts above.
Pete