Mergin duplicates from list but adding their values

So I tried to use Pivot Table and it is exactly what I needed, thanks very much HansVogelaar !

Unfortunately, it's not working yet as the values from "Resources" are already results from the sheet 1. If I type the datas and do a pivot table then, it works perfectly. But if the datas are coming from functions the SUM is not working.

Just in case it's relevant to share more details:

It is basically a tool. In "Sheet 1" I paste datas from a database which included useless informations.

They come like this :

So into the sheet 1 I need a few step to trim, then to join, and finally to rebuild my column :

Step 1: [H9] =IFERROR(IF(AND(E9=FALSE,F9=FALSE,G9=TRUE),TRIM(CLEAN(D9)),""),"")  {RESOURCES}

[J9] =IF(AND(E9=FALSE,F9=FALSE,G9=TRUE,D9<>""),LEFT(D8,LEN(D8)-1),"") {NEEDS}

Step 2: [K6] =TEXTJOIN(", ",TRUE,H8:H39)

Step 3: Text to Column

Step 4: [Q13] =INDEX(H8:J39,MATCH(N13,H8:H39,0),3)