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

Possibly, but not without seeing some data. Can you attach a file to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]