Showing data unigue to multiple columns in a pivot table
 

I have multiple columns of data with over 300 rows. I need to show entries
that are unique between two columns. For example if
Column A is Regulation, Column B is Regulated Material, Column C is product.

A B C
1 X 12 TY
2 X 12 CP
3 Y 12 TY
4 Z 15 TY

I want unique entrys only looking at column A and B. In this case there are
3 (rows 1 and 2 for column A and B are the same). I want to be able to put
this into a Pivot table or is there a way to do this with a pivot table? I
don't want to lose any of my other data because I will also need to be able
to sort and compare other columns as well.

Thanks so much!!

Showing data unigue to multiple columns in a pivot table
 

A PivotTable would be an excellent way to condense the data. Not sure what
other data you have that you are afraid to lose, but if you built a Table
with the A column as the far left Row field, and then added the B column to
the Row field, you should see a result similar to what you want. Note that
you may need to remove the 'subtotal/Grant total' lines, to clean things up.
If you then wanted then info from C column, simply add that to the Row field
as well.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lisaB" wrote:

I have multiple columns of data with over 300 rows. I need to show entries
that are unique between two columns. For example if
Column A is Regulation, Column B is Regulated Material, Column C is product.

A B C
1 X 12 TY
2 X 12 CP
3 Y 12 TY
4 Z 15 TY

I want unique entrys only looking at column A and B. In this case there are
3 (rows 1 and 2 for column A and B are the same). I want to be able to put
this into a Pivot table or is there a way to do this with a pivot table? I
don't want to lose any of my other data because I will also need to be able
to sort and compare other columns as well.

Thanks so much!!