crosstab producing only one record

[brwright]

I've filled a csv with data and crosstab is only giving me back one record. 

I dont understand what is breaking it. Maybe I need an ID to group by?

Here are screenshots; dirst of the csv content sample and secondly of the crosstab output.

[ddiesel]

There are so many different ways to do things in Alteryx! Glad we could help!