software

I have the following pivot table:

1 2 3 4 5
Totals

S (188.14)
05 (3.74)
EZ (3.74)
07 (3.20)
EZ (3.20)

The row levels 07 and EZ are always the same values and I would like to get
the data on the same row level however I can't figure out how to do this.
This section is a small subsection of a much larger table so it's isn't
workable to copy as values and paste.I'm a little confused with your pivot table layout. Are what you have as 1,
2, 3, 4, and 5 different fields? You can group items in a pivot table but
you can't group fields. I guess I don't understand the question correctly.

quot;Tim Whitleyquot; wrote:

gt; I have the following pivot table:
gt;
gt; 1 2 3 4 5
gt; Totals
gt;
gt; S (188.14)
gt; 05 (3.74)
gt; EZ (3.74)
gt; 07 (3.20)
gt; EZ (3.20)
gt;
gt; The row levels 07 and EZ are always the same values and I would like to get
gt; the data on the same row level however I can't figure out how to do this.
gt; This section is a small subsection of a much larger table so it's isn't
gt; workable to copy as values and paste.
gt;

Sorry for the confusion, please disregard the 1,2,3 etc.

I would like a way to group the two row fields but retain the row
descriptions so that it would look like this vs. the original example:

S (188.14)
05 (3.74)
EZ (3.74)
07 EZ (3.20)

Again the point is that the 07 and EZ fields are the same amount.quot;William Hortonquot; wrote:

gt; I'm a little confused with your pivot table layout. Are what you have as 1,
gt; 2, 3, 4, and 5 different fields? You can group items in a pivot table but
gt; you can't group fields. I guess I don't understand the question correctly.
gt;
gt; quot;Tim Whitleyquot; wrote:
gt;
gt; gt; I have the following pivot table:
gt; gt;
gt; gt; 1 2 3 4 5
gt; gt; Totals
gt; gt;
gt; gt; S (188.14)
gt; gt; 05 (3.74)
gt; gt; EZ (3.74)
gt; gt; 07 (3.20)
gt; gt; EZ (3.20)
gt; gt;
gt; gt; The row levels 07 and EZ are always the same values and I would like to get
gt; gt; the data on the same row level however I can't figure out how to do this.
gt; gt; This section is a small subsection of a much larger table so it's isn't
gt; gt; workable to copy as values and paste.
gt; gt;