Forum Discussion
transpose column into line
Hey guys.
Could you help me with the following question. I get a base where I have my column records.
I need to transpose the columns and place the record under those columns.
As shown in the example below.
I need this direct solution in Power Query.
Download Pbix.
https://drive.google.com/file/d/1Snwi6gq7vRYTNsn6Bt-9sSoX__TeHoMG/view?usp=sharing
This is called 'pivoting' but you need some extra information to make it work. Add a column that groups each set of three rows. One way to do this is to add an index column from 0 and integer-divide by three so that you have this:
then you can pivot COLLUM
Result:
2 Replies
- AlexisOlson
Super User
This is called 'pivoting' but you need some extra information to make it work. Add a column that groups each set of three rows. One way to do this is to add an index column from 0 and integer-divide by three so that you have this:
then you can pivot COLLUM
Result: