79553284

Date: 2025-04-03 14:55:02
Score: 1.5
Natty:
Report link

This got much easier 5 yrs later. Its a single cell formula producing a new spilled table:
=GROUPBY(Table1[[#All],[Pers]],Table1[[#All],[App_IDs]],ARRAYTOTEXT)

Or without producing the headers it may be easier to understand:
=GROUPBY(Table1[Pers],Table1[App_IDs],ARRAYTOTEXT)

Looks like this:

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Paschi