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.
