Pivot Query Puzzle

[trythis]

I have attached two pictures with notes. Please review and tell me what I need to change to make this work.

I am so close just not sure if I should add a field or what.

Also not sure what makes it put some items on its own row and some items are side by side.

Thank You,
For any help,
Tina

 

[trythis]

What I mean by add a field is a field that when I group by it will show all my names side by side not each in its own row.

Thanks,Tina