Hello,

I have a spreadsheet where I am trying to consolidate three columns of data
into one column which will keep only one of the three columns values.

Ex:

ColA ColB ColC
Med Bis IT
Eng Med Sci
Sci IT Med

I would want to merge these three just keeping any 'Med' values.