I have the following query :
My input table is
Basically I want to lookup columns for each ID. Value3>Value2>Value1
If value3 and value column has data then ouput should show ID having value3
If value3 has data present then populate output as Value3 , if value2 and value3 have data , then also it should populate value3
Output:
Is there formula I can write to retrieve this value?