Do you want to do this with worksheet functions or with VBA code (a macro)?
If we set it up using formulas and worksheet functions, then you'd have to
either retain the original row or come back behind things and do a copy /
paste special to convert copied values into absolutes so that you could
delete the original row of information. You've also got a lot of inserting
of rows and copying of formulas to do - depending on how far down the
worksheet your data goes, that could get rather tedious.

"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 . . .