Create list of unique records

Attached is a sample file.

I'd column A to have a list of all the unique IDs from columns D, F, H, J, L and N.

For each unique ID, I'd like column B to list each of the queries it was included in.

For example, the ID value BZB472532 appears as the second value for Q1, and as the first value in Q5 (and maybe other places, too, I don't know). So, it will be one of the Unique IDs, and in column B for that Unique value, it should list "Q1, Q5" (or just: 1, 5).

Finally, I'd like column C to list the highest score each Unique ID received.

I hope this makes sense.

I'm open to columns A, B and C staying where they are, or actually not being on the same worksheet as the raw data as it is in this Sample file. I put everything in this one sample worksheet for ease of viewing.

Can someone help me with this - and explain it to me, too, so I can keep learning about Excel?