I have a very large spreadsheet with only 2 columns, looks like this below:
The first column is the part #
The second column is the manufact.
I want to make a third column to identify every part# that has more than one
manufacturer, in this case it would be Part #D317001 because it has Jet004 &
Let001 as vendors for the same part. Sounds easy but i cannot get this to
work.
I setup a pivot table but the list is 40,000 lines long.
, please help if you can.

#DNV DNV001
#DNV DNV001
#D317001 JET004
#D317001 LET001
#D317001 LET001
#D317001 JET004
EB184 TIM006
EB184 TIM006
EB185 TIM006