Transpose rows to columns

[Anonymous]

Hello,

We need to transpose rows into columns and I'm not sure how, this would be our data (coming from Excel):

And this is the result we want:

What would be the way to achieve it?

TIA

[amitchandak · Accepted solution]

@Anonymous , Transpose in Power Query.

https://www.youtube.com/watch?v=I91NXohXl-o&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=13

Or show on rows in matrix Visual

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[HotChilli]

You use Transpose in Power Query.  You might have to Demote the Headers first