Forum Discussion
Transpose rows to columns
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
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/
2 Replies
You use Transpose in Power Query. You might have to Demote the Headers first
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/
