Forum Discussion
Multiple Rows transpose to Column
Hi, How can I unpivot 1 & 2 row to columns? e.g. 1st row value transpose to 1st column 2nd row value transpose to 2nd column if it was only 1 row-level header then it would have been e...
Honestly, there's a lot going on in your M code—way more than what was initially asked. If I were applying the code I shared across multiple files (assuming the sources are Excel workbooks), I’d first connect to each file using Excel.Workbook in a custom column, expand that column, select the needed sheets or tables, and then apply the logic I gave you—only to the actual data, not the Excel binary files.
Jihwan_Kim
Super User
Super UserHi,
Try to use Table.Transpose M function.
Table.Transpose - PowerQuery M | Microsoft Learn
Please check the below picture and the attached pbix file.
let
Source = source,
#"Transposed Table" = Table.Transpose(Source)
in
#"Transposed Table"