Pull out unique records + their sum totals from Query.

I'm trying to output the unique records and their sum count from an overall Query. Made a Loom video and FigJam for clariry. Any support is appreciated.

Loom : https://www.loom.com/share/561d76eb3d874fbb92ef8f1677ac14c1

FigJam : https://www.figma.com/file/igVbgCrUxgYAbE3QnqMUOc/Misc.?node-id=0%3A1&t=latBAHJMDy0Z7JnP-1