Hello everybody!

My name is Boris, I am new here. I feel quite confident with google so I rarely get to register in forums as usually my questions have already been asked and answered by somebody somewhere...

Having said that, I currently have a problem formulating what I am looking for in a concise manner (evident by the vague title), so it gets complicated finding an answer. Please, if what I am about to ask has been tackled somewhere, just point me in the right direction!

So, to the problem:
I have a column of, say, 100 cells (in reality about 1000). A1:A100

I need to print these on several sheets of paper, however I need to have two columns on one page. So essentially I need something like this:

Data from A1:A20 to go to B1:B20
Data from A21:A40 to go to C1:C20
Data from A41:A60 to go to B21:B40
Data from A61:A80 to go to C21:C40
and so on...

The only condition is that this should not be done with a VBA. I hope there is an answer to this, sounds so simple yet...

We can start with this as a main problem. If the solution to this is easy and evident, I would ask for further complications like if I want to resize the rows, and have only, say 10 rows per page, instead of 20, to have it dynamically resize the sheet as well, but let's start with that one.
_______________

Btw, other solutions that might still help me (if this is not possible) and would save at least some of the tedious work by hand would be any solutions that lead to the following:
Data from A1:A20 to go to B1:B20
Data from A21:A40 to go to C1:C20
Data from A41:A60 to go to D1:D20
Data from A61:A80 to go to E1:E20
and so on...


Thanks for reading this whole thing!

Cheers