I'm indexing computer hardware related info, one of the fields is called Vendor.
Example values of Vendor:
And so on...
I want to unify and display all values that contain the word 'Microsoft' and display them as one pie bucket. In a similar fashion, the values HP and 'Hewlett Packard' should be unified as HP, and so on.
I'm aware of the Include/Exclude options in a given visualization but using those return all matching values (not grouped)
What are my options?