Macro to move row data to columns

[catmom]

Thank you in advance for any help you can give me.

I have the following information extracted from a very old program:

[TABLE="width: 469"]
<TBODY>[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD]Berries Verified</SPAN>[/TD]
[TD="colspan: 2"]February 28, 2014 7:47:24 AM CST</SPAN>[/TD]
[/TR]
[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD]Apples Submitted</SPAN>[/TD]
[TD="colspan: 2"]October 10, 2012 3:31:18 PM CDT</SPAN>[/TD]
[/TR]
[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD]Oranges Approved</SPAN>[/TD]
[TD="colspan: 2"]April 5, 2013 5:48:11 PM CDT</SPAN>[/TD]
[/TR]
[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD]Berries Deploy</SPAN>[/TD]
[TD="colspan: 2"]January 29, 2014 9:59:14 AM CST</SPAN>[/TD]
[/TR]
[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD]Apples Approved</SPAN>[/TD]
[TD="colspan: 2"]January 9, 2013 1:37:54 PM CST</SPAN>[/TD]
[/TR]
[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD]Oranges Review</SPAN>[/TD]
[TD="colspan: 2"]January 15, 2013 11:31:41 AM CST</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL></COLGROUP>[/TABLE]


I need to get the data to look like this. I have been doing it cut and paste style and it is very time consuming. Is there a macro I can use to make it easier?


[TABLE="width: 1199"]
<TBODY>[TR]
[TD]Name</SPAN>[/TD]
[TD]Subject</SPAN>[/TD]
[TD]Apples Submitted</SPAN>[/TD]
[TD]Apples Approved</SPAN>[/TD]
[TD]Oranges Review</SPAN>[/TD]
[TD]Oranges Approved</SPAN>[/TD]
[TD]Grapes Start</SPAN>[/TD]
[TD]Grapes Completed</SPAN>[/TD]
[TD]Lemons Rev</SPAN>[/TD]
[TD]Lemons Baseline</SPAN>[/TD]
[TD]Berries Deploy</SPAN>[/TD]
[TD]Berries Verified</SPAN>[/TD]
[/TR]
[TR]
[TD]Bob</SPAN>[/TD]
[TD]Eating</SPAN>[/TD]
[TD="align: right"]10-Oct-12</SPAN>[/TD]
[TD="align: right"]9-Jan-13</SPAN>[/TD]
[TD="align: right"]15-Jan-13</SPAN>[/TD]
[TD="align: right"]5-Apr-13</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]29-Jan-14</SPAN>[/TD]
[TD="align: right"]28-Feb-14</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[catmom]

That's it! Brilliant! You have saved me days and days of work not to mention it will be accurate now. Thank you so much!

 

[hiker95]

catmom,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.