Quick support from the experts is needed to create a macro which step 1 & 2 below (this answer the question posted here - a follow up question will be posted now also to deal with another approach to the same problem):
1. takes the table in the attached excel file in sheet "Data". This is the sheet with the input to the Macro. The input table has the date displayed as a report and the challenge here is to create a tabel readable to Pivot Tables.
2. Needing macro to create an output of a table based only on 3 column headers "Project", "Milestone", "Date", see sheet "Macro_Output".