I need to print labels from an Excel list. Easy, just merge to Word.
There is a twist tho. My Excel list is as follows:
column A column B
Column B is the multiplier that dictates how many of each label i need. So in the example I'll need to create 5 labels with 'name1', 4 with 'name2' and 6 with 'name3'. My list goes up to name200 so clearly i dont want to do it manually. As a standard merge utilises one row per label, how do i replicate the rows in line with the number in column B?