Forum Discussion
excel
arrange one to 100 serial number in one page for printout. actually I have 1 to 1800 Serial number in A and B collum in single row .. how can i fit in C and D and E and F like screen shot
Adapted from WRAPCOLS with more than one column of data?
=LET(
orig, A2:B1801,
onr, ROWS(orig),
onc, COLUMNS(orig),
resr, 25,
resc, onc*ROUNDUP(onr/resr, 0),
MAKEARRAY(
resr, resc,
LAMBDA(r, c,
IF(
r+resr*INT((c-1)/onc)<=onr,
INDEX(orig, r+resr*INT((c-1)/onc), 1+MOD(c-1,onc)),
""
)
)
)
)