You have a list of 65000 rows of data. In the data you have things like dates that you do not necessarily need, but it's in the data. If you create a pivot table to get rid of the dates and roll up the information you do need, it may only then be 20,000 rows of data. But the pivot does not carry down the headings and you have to manually copy and paste. Is there a work around for this?