How to delete the headers in the Pivot Tables?

Question

After creating the Pivot Table shown below

I want to get a continuous list of dates with the year included as shown below

In order to get the data organized as shown above, I have copied and pasted all the values from the Pivot Table into a new sheet, deleted all the years and months headers and then organized all the values as a continuous list of dates with the year included. However, following the procedures above is time taking. Could you please let me know if there is any way to delete the years and months (headers)? Thanks in advance.

Answer 1

Is copy-pasting from the pivot table the quickest way to get your list of dates? I would have thought the easiest way to do that would be to type the first two dates and use the fill handle to do the rest.

Failing that, what you need to do is use filtering. With both columns selected, click Filter from the Sort & Filter dropdown in the Home ribbon. You'll get a dropdown next to each column; you can use this to either delete the rows you don't want, or copy-paste the rows you do want somewhere else. Or you can sort them into an order which will place the unwanted rows at the top.