Table manipulation

I have 5 append queries that enter records into a table. Each query has a field that specifies which query the record came from. The problem is some people can be entered in more than one query, and they print out multiple times. I would like to have a report that prints out something like below if an individual meets query 1, 2, and 3:

Name Q1 Q2 Q3

Is there a way I can either cut down the table size by moving the multiple "query" people into one record, or is there something I can do in the report to have them print out on one line?

Thank you