Paginate Rows into Columns in Excel

Solution 1:

Here's one way to do it.

In the example below, I placed the transformed range beside the original list (A1:A15).

In B1, enter this formula, and then copy it down and across:

=INDEX(original,((COLUMNS($B:B)-1)*3)+ROW(),1)

Where
original refers to A1:15

enter image description here

Just do a quick copy-paste-values move and then delete the original column. You could use another sheet for this.