Power Query editor rename the next 6 cells based on a value in a cell

[petermb72]

I have a report that somewhat looks like this in Power Query editor:

null	null	null	null	null
Date	10/1/2023	10/2/2023	10/3/2023	null
Volume	15	16	10	null
Total Hours	15	15	10	null
null	null	null	null	Job:RN
Date	10/1/2023	10/2/2023	10/3/2023	null
Volume	15	16	10	null
Total Hours	7	7	7	null
null	null	null	null	Job:CNA
Date	10/1/2023	10/2/2023	10/3/2023	null
Volume	15	15	10	null
Total Hours	8	8	3	null
Date	10/4/2023	10/5/2023	10/6/2023	null
Volume	12	14	15	null
Total Hours	14	14	14	null
null	null	null	null	Job:RN
Date	10/4/2023	10/5/2023	10/6/2023	null
Volume	12	14	15	null
Total Hours	7	7	7	null
null	null	null	null	Job:CNA
Volume	12	14	15	null
Total Hours	7	7	7	null

What I want it to look like is:

Date	Volume	Total hours
10/1/2023	15	15
10/2/2023	16	15
10/3/2023	10	10
10/4/2023	12	14
10/5/2023	14	14
10/6/2023	15	14

I need to eliminate the Rows that contain Job:*** and then the next three after it.  That way I would eliminate parts of the report that duplicate.  I can then manipulate the rest of the report to get the table looking correctly.  However I am stumped on on to eliminate a row with certain data and then the next three.  Is that Posiable?

[petermb72]

I missed the last row of dates in the sample data.  It would go in the row just after Job:CNA