I have a spreadsheet that looks like this:
What I need to do is create a new worksheet that has each row copied the number of times in the Qty column so Product 1 should be copied 10 times, product 2 twice and Product 3 just the once.
I have tried looking at other scripts on here for similar solutions, but cannot seem to get any of them to work right. I am using Exel v16 on Mac OS.
UPC | Product | Qty | Price |
123456789098 | Product 1 | 10 | 9.99 |
098765432123 | Product 2 | 2 | 7.00 |
456789098765 | Product 3 | 1 | 1.99 |
What I need to do is create a new worksheet that has each row copied the number of times in the Qty column so Product 1 should be copied 10 times, product 2 twice and Product 3 just the once.
I have tried looking at other scripts on here for similar solutions, but cannot seem to get any of them to work right. I am using Exel v16 on Mac OS.