Forum Discussion
How to wrap table, not vector (WRAPCOLS for tables)
Dear colleagues I have a long table of 5 columns and maybe 200 rows. The task is to wrap the table after a specified number of rows to see the table in landscape on a new sheet. I was thinking abo...
With Power Query that could be (for Biology; rws = 4):
// PQ_Bio
let
rws = 4,
Source = Excel.CurrentWorkbook(){[Name="T_Data"]}[Content],
FilteredBio = Table.SelectRows(Source, each ([Subject] = "Biology")),
RemovedSubject = Table.RemoveColumns(FilteredBio, {"Subject"}),
Hstacked = Table.FromColumns(
List.Combine(
List.Transform(Table.Split(RemovedSubject, rws), Table.ToColumns)
)
)
in
Hstacked