Pivot Tables - Filtering

[Monica Mills]

I have been trying for hours now to find out how to filter a set of data that has duplicate items; when I filter this data - on column B I get the right result but on column D the result repeats itself because there are only two curves that meet this criteria (XGR, XPOR). How can I get the pivot table to only show the two curves instead of repeating itself.

 

[GraH - Guido]

Hi,

Actually you are misreading your own pivot. The curve values as such are not repeated, they are only depending from the previous columns. Because Curve Name has different values, the curve values get "repeated". It is a coordinated table...
So get rid of the curve name column in the pivot and you will only get XGR and XPOR once for the filtered well Name.

 

[Monica Mills]

I need both Curve name and curve column; you see; these are from different sources. Column AB are from Source ("Apple") and column CD are from Source ("Pear"); I need to compare these sources.

 

[GraH - Guido]

can you upload your file please.
Perhaps there is a way to organize it differently.