Show all values in first column of Pivot Table

B

bmac

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table consolidation 1
how to use pivot data in formula or fuctions? 1
Copying values from pivot table to cells outside pivot table 4
Pivot Table Dates 1
Derived Columns in Pivot Table 1
Pivot Tables 4
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Column Totals - XL2003 5

Top