Forum Discussion

Zdenek_Moravec's avatar
Zdenek_Moravec
Copper Contributor
Jan 21, 2024

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...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 21, 2024

Hi Zdenek_Moravec 

 

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), "")
)

 

Resources