So we are running a soccer league, when student ssign up they answer questions. The issue with this report it is printing each question in its own row when I need a column header for each question. Below is a sample of what we might get. I tried doing a pivot table but was only able to pull the sum of the answer not the value of the field. I am not even sure how to describe the issue to look up solutions. Does anyone have a place to start?

Name Question Answer
John Height 5'
John Age 9
John Grade Fourth
John Gender Female
John Short Size Youth Medium
John Jersey Size Youth large
John Skill Level Beginner
Sally Short Size Youth Medium
Sally Height 55 in
Sally Gender Male
Sally Grade Third
Sally Age 9
Sally Jersey Size Youth Medium
Sally Skill Level Intermediate
James Gender Male
James Jersey Size Youth Medium
James Height 58"
James Grade Fourth
James Age 9
James Short Size Youth Medium
James Skill Level Intermediate
Ethan Gender Male
Ethan Age 9
Ethan Height 4 f 3''
Ethan Grade Fourth
Ethan Short Size Youth Medium
Ethan Jersey Size Youth Medium
Ethan Skill Level Intermediate

We would like to get something more like this.
Height Age Grade Gender Short Size Jersey Size Skill Level
John
Sally
James