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, ID Activity ID Activity Name Actual Finish Forecast Finish AL345 CMK14589130 Boring 2-Jun AL346 CMK14589131 trenching 13-Jun-13 AL347 CMK14589132 pit 14-Jun-13 CMK14589130 CMK14589131 CMK14589132 ID Date F/A Date F/A Date F/A AL345 6/2/2013 A 6/13/2013 A 5/17/2013 A AL346 7/21/2013 F 6/13/2013 F 6/25/2013 A AL347 7/28/2013 F 7/11/2013 F 6/14/2013 F

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter Chuy
Start date Jul 9, 2013
Tags

forecasting planning

Chuy

New Member

Jul 9, 2013

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,

ID	Activity ID	Activity Name	Actual Finish	Forecast Finish
AL345	CMK14589130	Boring	2-Jun
AL346	CMK14589131	trenching		13-Jun-13
AL347	CMK14589132	pit		14-Jun-13

	CMK14589130	CMK14589131	CMK14589132
ID	Date	F/A	Date	F/A	Date	F/A
AL345	6/2/2013	A	6/13/2013	A	5/17/2013	A
AL346	7/21/2013	F	6/13/2013	F	6/25/2013	A
AL347	7/28/2013	F	7/11/2013	F	6/14/2013	F