Seamus2626
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
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
I have to say it isn't clear to me what you are asking.
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!
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?
ASKER
Sorry my error, they are included and should be seperated (which i didnt do in tab Example)
Cheers
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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.
ASKER
Thanks Stephen!