I have a list of names with a second column listing a desired quantity.
I.E. Bob Smith 1
Lisa Smith 5
I need to return a list of values showing "Lisa Smith" 5x and Bob Smith 1x
Bob Smith
Lisa Smith
Lisa Smith
Lisa Smith
Lisa Smith
Lisa Smith.
I used an IF function to subtract column b and use "Lisa" again if B1-b2>0. This works but it skips the next 4 entries in the list until it reaches 0. Doesn't matter how it's sorted in the final. I just need a list for a variable data print run having each name occur however many times are shown in column b.
Bookmarks