Finding duplicated data in a SharePoint list, combining other list data into a collection

In my workflow I’m using a SharePoint Query a list function. Column A of the list contains user data (let’s say employee ID number). Column B contains a certain attribute of the user (let’s say “wears glasses,” “has blonde hair,” etc.). So if a user both wears glasses AND has blonde hair, they will appear twice in the list, once for the glasses and once for the hair.

What I want to do in my workflow is find these duplicates, based on the Column A attribute, and combine the Column B attributes into a collection that I can add to another SharePoint list. For example:

Current SharePoint list being queried:

New SharePoint list created using list data above:

Thanks for any help I can receive.