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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data and using Pivot table
- Thread starter Patsker64
- Start date
Similar threads
- Solved
- Question
