Please try at
A2
=IFERROR(INDEX('1. List Info I have'!A$2:A$12,MATCH(TRUE,INDEX(ISERROR(MATCH('1. List Info I have'!$A$2:$A$12&'1. List Info I have'!$B$2:$B$12,INDEX($A$1:$A1&$B$1:$B1,),)),),))&"","")
B2
=IF(A2="","",INDEX('1. List Info I have'!B$2:B$12,MATCH(TRUE,INDEX(ISERROR(MATCH('1. List Info I have'!$A$2:$A$12&'1. List Info I have'!$B$2:$B$12,INDEX($A$1:$A1&$B$1:$B1,),)),),)))
C2
=IF(A2="","",IF(COUNTIFS('1. List Info I have'!$A$2:$A$12,A2,'1. List Info I have'!$B$2:$B$12,B2)>1,INDEX('1. List Info I have'!$C$2:$C$12,MATCH(1,INDEX(('1. List Info I have'!$A$2:$A$12=A2)*('1. List Info I have'!$B$2:$B$12=B2),),))&" + ","")&LOOKUP(2,1/('1. List Info I have'!$A$2:$A$12=A2)/('1. List Info I have'!$B$2:$B$12=B2),'1. List Info I have'!$C$2:$C$12)
D2:F2
=IF($A2="","",SUMIFS('1. List Info I have'!D$2:D$12,'1. List Info I have'!$A$2:$A$12,$A2,'1. List Info I have'!$B$2:$B$12,$B2))
or Power Query
Bookmarks