yellowcabguy
Active Member
- Joined
- Dec 28, 2005
- Messages
- 440
Is there a way in a pivot table to combine columns of data into a new column. In the example below can I combine "cats" and "cat-Kitten" into a new column called CATS witha total of 22. Same issue for dogs.
Cat Cat-Kitten Dog Dog-Puppy
16 6 149 10
Cat Cat-Kitten Dog Dog-Puppy
16 6 149 10