Helping in creating a IF statement based on selections

[suciulaurentiu]

Hello, can you please help me with this issue, I am trying to solve it myself, but I need help.

If OM has indeed any value, I can show OM as text in the first column, if there not any value in the second column for OM, then, the row must go up and present AS with his value. If for AS there is no value, once more the row must go up and show UN, and etc.

Any ideas ?

OM	100​
AS	200​
UN	300​
GR	400​
AL	500​
GE	600​

 

[suciulaurentiu]

Update, i`ve found a nice thing, =IFERROR(TRANSPOSE(FILTER(..........x;.........y));"") which works for me.