C
Chance224
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
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