Autofill data from above cell while Grouping

[Vijaya Kanthi]

Hello

I need a macro to re-create the below auto generated report in the below format

Original source:

Process Code	Date	Population Size	Sample Size	Pass	Fail	Quality Percent
SLA-C&I Contracts C&I Query Portal		105	105	105	0	100
	02/07/2018	22	22	22	0	100
	03/07/2018	17	17	17	0	100
	04/07/2018	28	28	28	0	100
	05/07/2018	19	19	19	0	100
	06/07/2018	19	19	19	0	100
SLA-C&I Contracts D0155 Incoming Flows		123	123	123	0	100
	02/07/2018	12	12	12	0	100
	03/07/2018	23	23	23	0	100
	04/07/2018	16	16	16	0	100
	05/07/2018	59	59	59	0	100
	06/07/2018	13	13	13	0	100
SLA-C&I Contracts DCS CHASERS		704	704	704	0	100
	02/07/2018	1	1	1	0	100
	03/07/2018	1	1	1	0	100
	04/07/2018	1	1	1	0	100

<colgroup><col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;" span="7"> <tbody> </tbody>

I want repot in the below format:

Sub Process	Target	7/23/2018	7/24/2018	7/25/2018	7/26/2018	7/27/2018	7/28/2018
SWAN Dpg EELC L1	98%	-	-	-	-	-	-
SWAN Dpg EELC L2	98%	-	-	-	-	-	-
SWAN Dpg EELC L3	98%	-	-	-	-	-	-
SWAN Dpg EELC L4	98%	-	-	-	-	-	-
SWAN Dpg EELC L5	98%	-	-	-	-	-	-
SWAN Dpg EELC L6	98%	-	-	-	-	-	-
SWAN Dpg SIEM L1	98%	100	100	100	100	100	-
SWAN Dpg SIEM L2	98%	100	100	100	100	100	-

<colgroup><col width="448" style="width: 336pt; mso-width-source: userset; mso-width-alt: 16384;"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" span="6"> <tbody> </tbody>

Process code ( Source) will Sub process
Quality Percentage will be the data which needs to auto filled in the report and dates has to change according to the week....
if the macro can as for the dates while uploading the source...

Kindly advice

Regards,
K