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!
Bookmarks