Hello All, Ok so here is my data set
-- removed inline image ---
Top is what I have, bottom is what I need. Is there a Maccro way to do this? I tried using text to columns using the Alt H command to bring the data out, then indexing it down and that works for doing it 1 row at a time, but to preserve the data relationships I can't really do it for multiple columns As not all rows have multiple levels, and the ones that do do not have the same number of levels.
Any Help is appreciated.
Cheers.
-- removed inline image ---
Top is what I have, bottom is what I need. Is there a Maccro way to do this? I tried using text to columns using the Alt H command to bring the data out, then indexing it down and that works for doing it 1 row at a time, but to preserve the data relationships I can't really do it for multiple columns As not all rows have multiple levels, and the ones that do do not have the same number of levels.
Any Help is appreciated.
Cheers.