Automatically Break Multiple Rows to Two Columns
 

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!

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.

chuangbl wrote:

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!

--
chuangbl

--

Dave Peterson