Forum Discussion
hmowry
Dec 26, 2019Copper Contributor
Need a list to flow to next column, not next page
I need a way to input a long list into excel, but instead of having the list flow to the next page at the last row, I want it to flow over into the next column over on the same page. So instead of t...
SergeiBaklan
Dec 26, 2019Diamond Contributor
As variant, if you have the list in column A and fix the number of rows on the page as here in B1
you may use for C2 formula
=IF(ROW()<=$B$1+1,INDEX($A:$A,ROW()-ROW($C$1)+$B$1*(COLUMN()-COLUMN($C$1))),"")
and drag it to the down till space appears and then to the right. List could be on another sheet and details of the formula depends on how the result page shall be structured.