Calculated column by combining 2 other columns where column A is ref column has duplicate distinct values. If column 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.

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.