2 fields into 1 with unique values that is connected

[Nolgath]

hello guys,

I have a big question, is it possible to put 2 fields that have some values that are the same, into 1 field where you appears unique values AND if you use the new field for a filter for example then it is connected with the other 2 fields? So i can create a filter will all values available in those 2 fields in order to make it easier for the user? Or make a new dimension but with this new field with all unique values inside? 

for example:

seller_kam , buyer_kame

john,mike

elizabeth,sam

michel,igor

New field:

john

mike

elizabeth

sam

michel

igor

what you guys think?

[Nolgath]

This works, from this i understood that I have some issues in my data.