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:

Bob</SPAN>	Eating</SPAN>	Berries Verified</SPAN>	February 28, 2014 7:47:24 AM CST</SPAN>
Bob</SPAN>	Eating</SPAN>	Apples Submitted</SPAN>	October 10, 2012 3:31:18 PM CDT</SPAN>
Bob</SPAN>	Eating</SPAN>	Oranges Approved</SPAN>	April 5, 2013 5:48:11 PM CDT</SPAN>
Bob</SPAN>	Eating</SPAN>	Berries Deploy</SPAN>	January 29, 2014 9:59:14 AM CST</SPAN>
Bob</SPAN>	Eating</SPAN>	Apples Approved</SPAN>	January 9, 2013 1:37:54 PM CST</SPAN>
Bob</SPAN>	Eating</SPAN>	Oranges Review</SPAN>	January 15, 2013 11:31:41 AM CST</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL></COLGROUP>

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?

Name</SPAN>	Subject</SPAN>	Apples Submitted</SPAN>	Apples Approved</SPAN>	Oranges Review</SPAN>	Oranges Approved</SPAN>	Grapes Start</SPAN>	Grapes Completed</SPAN>	Lemons Rev</SPAN>	Lemons Baseline</SPAN>	Berries Deploy</SPAN>	Berries Verified</SPAN>
Bob</SPAN>	Eating</SPAN>	10-Oct-12</SPAN>	9-Jan-13</SPAN>	15-Jan-13</SPAN>	5-Apr-13</SPAN>					29-Jan-14</SPAN>	28-Feb-14</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>

 

[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.