Need a list to flow to next column, not next page

[hmowry]

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?

[#2]

@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.