transpose column into line

[Anonymous]

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 

[Anonymous]

Spectacular, saved my weekend. Thank you very much

[AlexisOlson · Accepted solution]

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: