Calculated column by combining 2 other columns where Colum A is ref colum has duplicate distinct values. If colum B has result any row for that specific Ref in column then same should be the result and will not overwrite the column C if any Row is blank from Column B. If Column B is blank for all ref as per column A then column C result should come in end result.
| Column A | Column B | Column C |
|---|---|---|
| India | ||
| China | T1 | |
| India | T2 | T3 |
| China | T4 | |
| Russia | T3 | |
| Russia | ||
| Rome | T2 | |
| Japan | T1 | |
| Rome | ||
| Japan | T3 |
| Column A | Column B | Column C | Result |
|---|---|---|---|
| India | |||
| China | T1 | T1 | |
| India | T2 | T3 | T2 |
| China | T4 | ||
| Russia | T3 | T3 | |
| Russia | T0 | ||
| Rome | T2 | T2 | |
| Japan | T1 | T1 | |
| Rome | |||
| Japan | T3 |