Excel: Copy row of cells X times based on number in a column

I am completely new to VB so bear with me please! I sometimes have a spreadsheet with data like this: QTY Ref Des 1 U5 5 C1,4,8-10 3 R10,23,48 1 L2 And I need to expand those "combined" lists so each "ref des" has its own row like this: QTY Ref Des 1 U5 1 C1 1 C4 1 C8 ... and so on. There is additional data in the spreadsheet rows, these are just the 2 columns that need to be modified during the operation, the rest can just be duplicated/copied. Any ideas? Thanks

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of October 24, 2014.

For more resources for Microsoft Excel