I don't know how to do this, like a hierarchy

[D19PAL]

Hi,

By ID find out if its say for example top, middle or bottom.

ID,A,B,C

1,YES,YES,YES

2,,YES,YES

3,,,YES

So look per ID and row, and find where the yes is, if in A then top, if in b then medium and if in C then low

In script please 

Thanks

[Taoufiq_Zarra]

@D19PAL  can you share a sample data and the expected output ?

[D19PAL]

Sample data is there

ID,outcome

1,top

2,middle 

3,bottom 

[anat]

load ID,if(match(A,'YES'),'Top',
if(match(B,'YES'),'Middle',
if(match(C,'YES'),'Low')
) )as test;