List Unique Values from multiple columns

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top