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!