Automatically Break Multiple Rows to Two Columns

[chuangbl]

I have a long list of rows in Excel, consisting of 2 columns (Column A:
Item & Column B: Quantity), as shown in the example below:

A B
---------------
Item Qty
---------------
AAA 12
BBB 130
CCC 14
DDD 150
EEE 22
FFF 230
GGG 333

I want to automatically break the long list of rows at every Nth row
into another 2 columns (Column E & F). Example as shown below:

A B E F
-------------------------------
Item Qty Item Qty
-------------------------------
AAA 12 FFF 230
BBB 130 GGG 333
CCC 14
DDD 150
EEE 22

Can anyone help how I can do so using Macro or any Excel functions?
Thank you!

 

[Dave Peterson]

Is this so you can print lots of stuff on one sheet of paper?

If it is, you may want to copy the data to MSWord and use Format|columns to make
it pretty.

If this isn't for printing, I think you'll find that you can do lots more things
with your data laid out the way you have it--save a copy before you modify your
layout.