Combining Columns keeping only one value
What is med value? A string which contains 'med'?
Create a helper col where you can have a concatenate with if to get the med
value then convert to value and delete first three cols
=concatenate(if(condition checking for med in a1,a1,"")&if(condition
checking for med in b1,b1,""),if(condition checking for med in c1,c1,""))
"David" wrote:
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.
|