Extracting Alt Enter data by Creating rows underneath using macros

[Biogreg]

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.

 

[Biogreg]

[TABLE="width: 416"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]In 1 Row the data is
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
B
C
D
E[/TD]
[TD]1
2
3
4
5[/TD]
[TD]Happy
Go
Lucky
Fun
Times[/TD]
[TD]Data Point 1[/TD]
[TD]Data Point 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I need it in 5 rows
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD]Happy[/TD]
[TD]Data Point 1[/TD]
[TD="colspan: 2"]Data Point 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[TD]Go[/TD]
[TD]Data Point 1[/TD]
[TD="colspan: 2"]Data Point 2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]3[/TD]
[TD]Lucky[/TD]
[TD]Data Point 1[/TD]
[TD="colspan: 2"]Data Point 2[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]4[/TD]
[TD]Fun[/TD]
[TD]Data Point 1[/TD]
[TD="colspan: 2"]Data Point 2[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]5[/TD]
[TD]Times[/TD]
[TD]Data Point 1[/TD]
[TD="colspan: 2"]Data Point 2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

There are hundreds of rows like this out of thousands, and there are 6-7 columns of information like this that needs to be treated. Once again thanks for the help.