combine long list to fill a page at a time

dkent1982 I'm not sure I understand, but if you want to 'wrap' your list and you have excel 365 then I created a LAMBDA function in the attached to do that.  The formula is:

ReshapeXrows = lambda(in,rows,LET(i, EXPAND(in,ROUNDUP(ROWS(in)/rows,0)*rows,,""),
                   DROP(REDUCE("", SEQUENCE(ROUNDUP(ROWS(i)/rows,0),,0,rows), 
                      LAMBDA(u,v, HSTACK(u, CHOOSEROWS(i, SEQUENCE(rows)+v)))),,1)))

so do a print preview of the existing list and zoom in/out to the size you want and see how many rows are shown.  Then on new worksheet use above lambda function to create the wrapped version:

=ReshapeXrows( [originalData], [numberRows] )

Then print this new sheet (make sure to set your zoom accordingly or just set to 'fit all rows'

Patrick2788 , HansVogelaar  is there an easier way to make this 'wrap around' function?  Am I missing something that already exists?