Transpose groups of rows into Columns

try this

Hi  Anonymous ,

Check my similar thread below:

Solved: Turn 2 columns into multiple columns based on a no... - Microsoft Power BI Community

It has detailed steps inside.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

For this scenario, I would split the table into page sizes of 4 rows, and then Transpose and Promote the Headers in the list of tables.  Then you can just expand them!

let
Source = Excel.CurrentWorkbook(){[Name="Products"]}[Content],
Custom1 = List.Transform(Table.Split(Source, 4), each Table.Transpose(_)),
Custom2 = List.Transform(Custom1, each Table.PromoteHeaders(_)),
#"Converted to Table" = Table.FromList(Custom2, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandTableColumn(#"Converted to Table", "Column1", {"Product_id", "Date", "Unit", "Revenue"}, {"Product_id", "Date", "Unit", "Revenue"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"Product_id", type text}, {"Date", type text}, {"Unit", type text}, {"Revenue", type text}})
in
#"Changed Type"

--Nate