Solved: How to transpose and shape a table

caseski · ‎11-10-2022

Hi all, I have a table like this:

And I want to create a new table based on previous like this:

Is it possible?

Bifinity_75 · ‎11-10-2022

Hi @caseski , in Power Query, select COD column, and select Unpivot others columns, like the image:

The result:

Best regards

Bifinity_75 · ‎11-10-2022

Hi @caseski , in Power Query, select COD column, and select Unpivot others columns, like the image:

The result:

Best regards

How to transpose and shape a table