If you are running XL2010 or later then you can unpivot your data using Power Query. In later versions, it is called Get and Transform Data and found on the Data Tab of the Ribbon. If you repost your data using XL2BB then we can show you exactly how to do this. Otherwise, google unpivot data with Power Query for a tutorial.