Using these array formulas in E4 and F4 and filled down should work. To confirm array formulas you must press CTRL+SHIFT+ENTER, not just ENTER.
E4 (to get distinct list of Item values from list in A3:A11):
Formula:
=IFERROR(INDEX($A$3:$A$11,MATCH(0,COUNTIF($E$3:E3,$A$3:$A$11),0)),"")
F4 (to get delimited strings of the types linked to the distinct values):
Formula:
=TEXTJOIN(", ",TRUE,IF($A$3:$A$11=E4,$B$3:$B$11,""))
Formula structures from:
E4: https://sfmagazine.com/post-entry/ap...with-an-array/
F4: https://www.ablebits.com/office-addi...istinct-values
Bookmarks