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!