Formula Help - Please

Hi Tom,

That could be formula

=IF( RIGHT(A2,2)*1=1, IF(ISBLANK(B2),"",B2), IF(ISBLANK(B2),C1,B2))

or Power Query which is more preferable if you have thousands of updating records

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    AddThirdColumn = Table.AddColumn(Source, "C", each
        if Text.End([A],2) = "01" then
            if [B] = null then "" else [B]
        else [B]),
    FillDown = Table.FillDown(AddThirdColumn,{"C"})
in
    FillDown

Alternatively you may use PQ to connect to your SQL database and made transformation within that query returning final result.

Both variants are in attached