Quick support from the experts is needed to create a macro to accomplish step 2 below (I will post another question today under my username to see if an approach I suggest can lead to the answer:
1. takes the table in the attached excel file in sheet "Data". This is the sheet with the input to the Macro.
2. Needing macro to create an output of a table based as per sheet "RESULT WANTED".
Clarification on step 2 (following explanation referencing sheet "RESULT WANTED".
-The grey section i.e. column headers (C3:P3) is fixed label and the rows headers (A4:A107) stay with same labels.
-The projects that match the label (for example: RFQ-Est. and week "2015..Wk3" its project name should be written in that cell (for example as in cell B6).
-In this case there are two projects which fulfill this criteria so both are included in the same cell, where each consequent project after the first one in that cell (others where more than one project fulfill the same criteria) and are entered in the same cell but in the next line below (manually one would hit SHIFT+ENTER).