Quake3World

So I have an excel document with two columns. in the first one there's a series of numbers from 0001 to 3000. in the second column is a constant price, $12.00.
___________
|item# |Price|
| 0001 | $12 |
| 0002 | $12 |
| 0003 | $12 |
| 0004 | $12 |
~~~~~~~~~

i'm trying to merge this into a word document so that labels can be printed out with the item # and price on each label. that i have no problem doing. the issue is that instead of creating the labels from top to bottom it's doing it from the left to to right. in essence i'm getting:

label 01 - label 02 - label 03 - label 04
label 05 - label 06 - label 07 - label 08
label 09 - label 10 - label 11 - label 12

when i want.

label 01 - label 21 - label 41 - label 61
label 02 - label 22 - label 42 - label 62
label 03 - label 23 - label 43 - label 63

each page has 4 columns and 20 rows so there are 80 labels per page.

is there a way in word to flip the invert the columns and rows while still keeping the amount of rows and columns intact? or is there somehow a way to create a macro in excel that would number the first column for me by going:

0001
0021
0041
0061
0002
0022
0042
0062
etc...

if anyone can help it would be greatly appreciated.

Look for Avery label maker - I think it may have an import functionality that can do that. Not 100% sure, but worth a try.