Data and using Pivot table

Patsker64

New Member
Joined
Feb 27, 2007
Messages
3
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?
 

Forum statistics

Threads
1,082,551
Messages
5,366,281
Members
400,882
Latest member
zaldy_a

Some videos you may like

This Week's Hot Topics

Top