Hi Megan,

Drag the answer (1-5) column head to the "Columns" box in the Pivot Table List. This will create separate columns for each answer.

I hope that helps.