Forum Discussion

hmowry's avatar
hmowry
Copper Contributor
Dec 26, 2019

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 this

Apples

Bananas

Cherries

Dates

Elderberry

--------------(end of page)

Fig

Grapes

 

it would look like this:

Apples          Figs

Bananas        Grapes

Cherries

Dates

Elderberry

 

Is this even possible?

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 26, 2019

    hmowry 

    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.