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 about WRAPCOLS, but it works only for vector (one column). Is there a way to wrap whole table using M365 functions? If not, the next option can be Power Query.
See example attached.
Thank You very much for any hint.
Zdenek Moravec
Cesky Krumlov, Czechia
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
14 Replies
Would this work for you (Biology; 4 rws)?:
=LET( rws, 4, data, FILTER(T_Data[[Question]:[Answer4]], T_Data[Subject] = "biology"), k, SEQUENCE( ROUNDUP( ROWS(data) / rws, 0)-1 ), Stack, LAMBDA(seed,n, HSTACK(seed, TAKE( DROP(data, rws*n), rws) ) ), IFNA( REDUCE(TAKE(data,rws), k, Stack), "") )
