How do i change date from in a pivot table to normal data

[catling94]

I am trying to summarise data wherein alot there are alot of blanks. The only way to list this data properly therefore is by using a pivot table, selecting the parts i want and then filtering them by a seperate coulumn, in this case 'reinsurer'.

How do i do the same thing, but outside of a pivot table, or even better, just adapt that pivot table into normal data.

I hope that is clear, any further quesions please ask!!