Often data is stored in crosstab format, and you need to 'unpivot' the data, to normalise it and make it more usable as a pivot source.

There are several methods you can use to restructure your data - I've written a tutorial for one method, whch works quickly and easily for simple cases.

http://excel.solutions/2014/03/unpivot-excel-data/

Feedback welcome!