Show all values in first column of Pivot Table
 

Hello, I have a pivot table with columns A through M and rows 1 - 14,000
I have some duplicate values in coumn A. The values in columns B through M
are not unique within each column. Excel is grouping items B as shown below.

A
B1
B2

And I want --
A B1
A B2

Any help appreciated,

Thanks

Show all values in first column of Pivot Table
 

bmac,

You need to copy the pivot table and paste values somewhere else. Then
select that new table with the values, use Edit / Go To... Special Blanks,
then type =, press the up arrow key once, and press Ctrl-Enter. Then copy
the entire new table again, and paste special values.

HTH,
Bernie
MS Excel MVP


"bmac" wrote in message
...
Hello, I have a pivot table with columns A through M and rows 1 - 14,000
I have some duplicate values in coumn A. The values in columns B through M
are not unique within each column. Excel is grouping items B as shown
below.

A
B1
B2

And I want --
A B1
A B2

Any help appreciated,

Thanks

Show all values in first column of Pivot Table
 

bmac wrote:
Hello, I have a pivot table with columns A through M and rows 1 - 14,000
I have some duplicate values in coumn A. The values in columns B through M
are not unique within each column. Excel is grouping items B as shown below.

A
B1
B2

And I want --
A B1
A B2

Any help appreciated,

Thanks

Not totally sure, but you could try concatenating the columns that feed
A and B in the source data, then use that in your PT instead of separate
columns.