Index Match Multiple Lines of Data based on changing Queries

[Detonator12]

Hello, i have modified a couple of formulas I found, but am struggling to make them dynamic enough without having to edit the formula when copy pasting.

All of this data below is reading from another sheet based on "JOB DESCRIPTION 1" field. Is there a way I can modify this formula below, to handle easier copy pasting without modifying the formula?

Cell C40 is the first job description in this example. When copy pasted i need to modify it, and also modify the ROWS(C$42:C42) parts of the formula.
Then its dragged down per column.

=IFERROR(IF(ROWS(C$42:C42)>COUNTIFS('Detailed Breakdown'!B:B,$C$40),"",INDEX('Detailed Breakdown'!$C$1:$C$9999,SMALL(IF('Detailed Breakdown'!$B:$B=$C$40,ROW('Detailed Breakdown'!$C$1:$C$9999)-ROW('Detailed Breakdown'!$C$1)+1),ROWS(C$42:C42)))),"")

JOB DESCRIPTION 1
Concrete pump	5	Day
Supply and Install Reinforcement	5	t
Form Work Install Rate	5	M2
Trench and Backfill: 300-600mm width to depth 1400mm Trench	6	m
JOB DESCRIPTION 2
Concrete Supply ONLY	5	M3
Form Work Install Rate	5	M2
Place and Compact Fill around Structures 750mm width	5	m3

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[JPARKHURST]

You are having to modify the formula to accomodate for the job description because each description is of different length, correct? Or is there soem other reason?

Are all job Descriptions the same, eg: "Job Description" + increasing value?

Jon