How to get all columns per row

[Anonymous]

Hi i have the next database

I want to transform the data to achieve this:

 

Any idea on how to do it?

[BA_Pete · Accepted solution]

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

[Anonymous]

Thank you so much