Consolidate forecasts and actual dates into one column with a helper column

[Chuy]

I am looking to see how to convert raw data as shown in the 1st table and manipulating the data to display as shown in the 2nd table. Specifically, I want the dates to be in a single column with a second column marking if the date is an actual or forecast. Any help would be greatly appreciated. Thanks,[TABLE="width: 500"]
<tbody>[TR]
[TD]
[TABLE="width: 405"]
<tbody>[TR]
[TD="class: xl68, width: 106, bgcolor: silver"]ID
[/TD]
[TD="class: xl68, width: 96, bgcolor: silver"]Activity ID
[/TD]
[TD="class: xl68, width: 151, bgcolor: silver"]Activity Name
[/TD]
[TD="class: xl68, width: 86, bgcolor: silver"]Actual Finish
[/TD]
[TD="class: xl68, width: 100, bgcolor: silver"]Forecast Finish
[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 106, bgcolor: transparent"]AL345
[/TD]
[TD="class: xl69, width: 96, bgcolor: transparent"]CMK14589130
[/TD]
[TD="class: xl69, width: 151, bgcolor: transparent"]Boring
[/TD]
[TD="class: xl70, bgcolor: transparent"]2-Jun
[/TD]
[TD="class: xl71, width: 100, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 106, bgcolor: transparent"]AL346
[/TD]
[TD="class: xl69, width: 96, bgcolor: transparent"]CMK14589131
[/TD]
[TD="class: xl69, width: 151, bgcolor: transparent"]trenching
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 100, bgcolor: transparent"]13-Jun-13
[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 106, bgcolor: transparent"]AL347
[/TD]
[TD="class: xl69, width: 96, bgcolor: transparent"]CMK14589132
[/TD]
[TD="class: xl69, width: 151, bgcolor: transparent"]pit
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 100, bgcolor: transparent"]14-Jun-13
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 464"]
<tbody>[TR]
[TD="class: xl149, width: 109, bgcolor: white"][/TD]
[TD="class: xl263, width: 160, bgcolor: #92D050, colspan: 2"]CMK14589130
[/TD]
[TD="class: xl265, width: 173, bgcolor: yellow, colspan: 2"]CMK14589131
[/TD]
[TD="class: xl267, width: 174, bgcolor: #92D050, colspan: 2"]CMK14589132
[/TD]
[/TR]
[TR]
[TD="class: xl185, width: 109"]ID
[/TD]
[TD="class: xl214, width: 90"]Date
[/TD]
[TD="class: xl215, width: 70"]F/A
[/TD]
[TD="class: xl216, width: 101"]Date
[/TD]
[TD="class: xl216, width: 72"]F/A
[/TD]
[TD="class: xl217, width: 90"]Date
[/TD]
[TD="class: xl218, width: 84"]F/A
[/TD]
[/TR]
[TR]
[TD="class: xl269, width: 109"]AL345
[/TD]
[TD="class: xl276"]6/2/2013
[/TD]
[TD="class: xl277"]A
[/TD]
[TD="class: xl273, bgcolor: white"]6/13/2013
[/TD]
[TD="class: xl273, bgcolor: white"]A
[/TD]
[TD="class: xl271"]5/17/2013
[/TD]
[TD="class: xl272"]A
[/TD]
[/TR]
[TR]
[TD="class: xl270, width: 109"]AL346
[/TD]
[TD="class: xl271"]7/21/2013
[/TD]
[TD="class: xl272"]F
[/TD]
[TD="class: xl278, bgcolor: #EEECE1"]6/13/2013
[/TD]
[TD="class: xl278, bgcolor: #EEECE1"]F
[/TD]
[TD="class: xl274, bgcolor: white"]6/25/2013
[/TD]
[TD="class: xl272"]A
[/TD]
[/TR]
[TR]
[TD="class: xl270, width: 109"]AL347
[/TD]
[TD="class: xl271"]7/28/2013
[/TD]
[TD="class: xl272"]F
[/TD]
[TD="class: xl273, bgcolor: white"]7/11/2013
[/TD]
[TD="class: xl273, bgcolor: white"]F
[/TD]
[TD="class: xl276"]6/14/2013
[/TD]
[TD="class: xl277"]F
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]