Auto-create row from column values
I have a list of inventory items that I need to import into a computer system. The end-user gave us a spreadsheet with each row representing a different item. He populated the columns beside it with the inventory quantity of different sizes or flavors.
My issue is that I need a separate row for each item & size, etc...
Is there a simple solution to auto-create a list based on the info above? It doesn't have to be pretty...just accurate.
Thanks
|