Forgot to mention/caution: try this out on a copy of your workbook or
worksheet in case I messed something up. Either it works and you can then
use the copy to overwrite the original, or it doesn't work and you can yell
at me, but you'll still have your original data in one piece.

"willc" wrote:

Thanks for the reply . . . and VBA would be great. The more automated the
better. There will be several hundred rows. Thanks again for the help.

"willc" wrote:

Folks,

I have a multi-column excel spreadsheet where one column has a text string
that I need to explode into individual rows while keeping the adjacent column
data. I doubt I'm using the correct nomenclature so I'm putting an example
of what I'm attempting below.

Thanks for any help on this.

A B C A
B c
store a typea a,b,c,d what I want is: store a typea a
store b typeb e,f,g,h store a typea
b
store a
typea c
store a
typea d
store b
typeb e
etc . . .