Need help with Excel macro for some data processing

**AirBeast** · 01-14-2014, 07:37 PM

Hi folks - I have a large spreadsheet (over 100,000 rows) with 10 columns of data. Two of the columns have comma separate value entries. I need a macro (or series of macros) that can automatically duplicate rows of data with only a single entry for each such comma separated value.

so today I have: John | Smith | Virginia | Apples, Bananas, Grapes, Mangoes

And I want:

John | Smith | Virginia | Apples
John | Smith | Virginia | Bananas
John | Smith | Virginia | Grapes
John | Smith | Virginia | Mangoes

I need the macro to be "smart enough" to only create duplicate rows for the number of entries in the CSV cell. So, in my example, I had 4 fruit names. If I had 17 fruit names, I'd want 17 rows, each with a single instance of each fruit. If there are two identical fruit names, that's okay - I can live with two duplicate rows of the same exact fruit name.

Thoughts on how to do this??

**mgs73** · 01-14-2014, 08:10 PM

Try this - I think it should do what you want.

Please Login or Register  to view this content.

**arlu1201** · 01-15-2014, 01:03 AM

Thread posted in CS subforum, hence closed.

Airbeast, you are duplicating efforts by posting it in both the paid and free forums. Please avoid doing so.

Thanks,
Admin