Merge multiple rows into one row

We are using CF10. I am writing a query that feeds into an adobe report builder report. Several tables are involved.

I need the name, address, and the checklist items on one row. There can be up to 3 checklist items per name, one name, one address.

The data looks something like this

The output should look like this:

Joe Student     123 Main     HI     PD

Sam Student   123 Main    JP

Anne Student   123 Main    HI     JP