Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Seperate by comma and stack

Hi,
I have attached a spreadsheet where i would like the names in Column D to be split out and stacked on top of each other

In the tab example i have laid this out. So when we split the names and stack them, i would like to keep the data from the adjacent columns for each new split

So the process is to split out the names and keep the data from cells A,B,C+E

Any help would be greatly appreciated!

Thanks
Seamus
test.xls
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

I have to say it isn't clear to me what you are asking.
Avatar of Seamus2626

ASKER

Hey Stephen,

Where there is multiple names in a cell (in Col D), i need these names to be cut, a new row inserted and the name pasted into Col D of the new row.

I can then use formula to get matching data

The first thing i need though is to seperate the names in Col D (Where there is Multiples e.g. D7) and then insert a row, or two, or three (dependant on how many names, in D7, one new row) and then paste the multiple name in, with D7, Michael Finance would be cut and pasted into the new row(D8)

Hope thats clearer!
OK, I see now. I was sidetracked by the red cells - are they excluded from this operation because they seem to be the same in both sheets?
Sorry my error, they are included and should be seperated (which i didnt do in tab Example)

Cheers
ASKER CERTIFIED SOLUTION
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect Stephen, very good!!

Out of interest, how does that code work, i see it clears contents, where does it get the information back from?
It puts the range into an array before deleting the contents and then the array is transferred back to the worksheet.
Thanks Stephen!