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

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

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.