Is there a way to extract a list of unique values from multiple columns? I
have a file that I track which job an asset is on each day of the month.
Example:
A B C D
Asset 6/01 6/02 6/03
Pump Job1 Job1 Job2
Pump2 Job1 Job3 Job3
Pump3 Job2 Job2 Job1

The exact would then list:
Job1 Job2 Job3

This would be listed across with each unique job being listed in a cell.

Thanks