This video shows you how to use the new Unpivot functionality in Qlik Sense 3.1 - that shows you how to load pivot table or crosstabular data as a source into your app.
Sample data and app is attached to this document.
NOTE: To increase resolution or size of the video, select the YouTube logo at the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube.