dyaron
Active Member
- Joined
- Nov 26, 2007
- Messages
- 291
I don't want to supress the numbers in the columns created in the Rows area. I want to see all the information, regardless of whether there are duplicates or not. I am aware that this defeats the purpose of a pivot table, but sometimes, I have to manually copy and fill down each category, because I use the results of pivot tables to create Unique keys for additional analysis. Is this possible? I want the information to look as follows:
(NOTE: I'm using periods, so I can line up the data under the "Category" columns, this is not a real part of the data...simply emulating "spaces")
Raw Data (Before Pivot Table)
Category 1.....Category 2.....
111..............abc
222..............bcd
111..............cde
111..............def
222..............efg
222..............fgh
111..............ghi
111..............hij
111..............ijk
What it looks like (standard pivot):
Category 1.....Category 2......
111...............abc
....................cde
....................def
....................ghi
....................hij
....................ijk
222...............bcd
....................efg
....................fgh
What I WANT it to look like:
Category 1.....Category 2......
111...............abc
111...............cde
111...............def
111...............ghi
111...............hij
111...............ijk
222...............bcd
222...............efg
222...............fgh
At first look, this appears to be simply "Sorting", however, when I have 30 columns, How do I sort 30 columns? If we can achieve this in Pivot tables that would be great... I've looked everywhere and can't figure it out. Any help is appreciated. Thanks!
(NOTE: I'm using periods, so I can line up the data under the "Category" columns, this is not a real part of the data...simply emulating "spaces")
Raw Data (Before Pivot Table)
Category 1.....Category 2.....
111..............abc
222..............bcd
111..............cde
111..............def
222..............efg
222..............fgh
111..............ghi
111..............hij
111..............ijk
What it looks like (standard pivot):
Category 1.....Category 2......
111...............abc
....................cde
....................def
....................ghi
....................hij
....................ijk
222...............bcd
....................efg
....................fgh
What I WANT it to look like:
Category 1.....Category 2......
111...............abc
111...............cde
111...............def
111...............ghi
111...............hij
111...............ijk
222...............bcd
222...............efg
222...............fgh
At first look, this appears to be simply "Sorting", however, when I have 30 columns, How do I sort 30 columns? If we can achieve this in Pivot tables that would be great... I've looked everywhere and can't figure it out. Any help is appreciated. Thanks!