Use the unpivot functionality in Power Query (a free Excel add-in) to easily turn your cross-tabbed data into a more normalized structure. The normalized data structure will grant you the flexibility to create additional analyses in a more efficient manner.

See also:

• Get Out of the Spreadsheet Abyss
• Perform Fuzzy Lookups / Approximate String Matching in Excel

Download: Power Query Excel Add-In

If you’re interested in Business Intelligence & Tableau please subscribe and check out my videos either here on this site or on my Youtube channel.