Forum Discussion
Solved
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...
My approach is to leave the table as a 2D array and pull out what's needed in blocks.
=WrapRows2Dλ(DROP(Snapλ(T_Data,"Biology"),,1),4,"")Snapλ is a convenience Lambda for quick filtering without having to supply a Boolean vector.
WrapRows2Dλ has three arguments - array, new_height (4 for this example), and an optional pad_width (empty string here).
WrapRows2Dλ / WrapCols2Dλ: Fast, efficient 2D wrapping without flattening | Microsoft Community Hub
Hi Zdenek_Moravec,
You can try the following formula in an empty cell of the Biology and Chemistry sheets.
=LET(
calc, TEXTSPLIT(TEXTJOIN(";",,
BYROW(IFNA(WRAPCOLS(
BYROW(FILTER(T_Data[[Question]:[Answer4]], T_Data[Subject] = A1),
ARRAYTOTEXT), 4), ""),
ARRAYTOTEXT)), ", ", ";"),
IFNA(IFERROR(--calc, calc), "")
)Hope this helps.
IlirU