Transpose rows, distributing them in columns? / Transpor linhas, distribuindo-as em colunas?

luccagrtt501st 

Steps TableSplit through CombinedTables cannot be done with the Power Query User Interface, you have to implement them with the Advanced Editor

In the attached file I updated the query to add some comments (lines start. with //), this gives:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    // Remove empty rows:
    RemovedNull = Table.SelectRows(Source, each ([Column2] <> null)),
    // Split the table every 7 rows ==> A list of Tables:
    TableSplit = Table.Split(RemovedNull, 7),
    // Iterate over the list to Transpose each item (each Table):
    TransposedEachTable = List.Transform(TableSplit, Table.Transpose),
    // Combine list items as a Table:
    CombinedTables = Table.Combine(TransposedEachTable)
in
    CombinedTables

Power Query doc. is available here. Any specific question re. the above query let me know

And good luck with PQ, learning it is a journey...