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...
=LET(a,FILTER(Data!A2:F21,Data!A2:A21=A1),r,4,IF(ROWS(a)<=r,a,IFNA(TAKE(REDUCE(a,SEQUENCE(ROWS(a)/r),LAMBDA(x,y,HSTACK(x,DROP(a,y*r,1)))),r),"")))
