You will need to normalize your data to be in a state where a pivot table can be created. This means unpivoting your data so that the dates are not horizontal but vertical. If you are using XL2010 or later, I would urge you to see how this is done in Power Query so that you can create a table. Firstly, you will need to eliminate all columns you do not need in the Pivot Table and then unpivot your date data. Here is a link on how to unpivot in Power Query.