Power Query copy from Status2 to Status1

[Mohammednt0]

Good Day

by using power query,

how to copy from Status2 to Status1 only if there is value in Status 2 Without adding any other column just copy or replace, is this possible?




file is attached

[hamster]

try

Code: Select all

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    RV =
        Table.ReplaceValue(Source, each [Status1],
            each if [Status2] = null then Text.Trim([#"Status2(Status1)"]) else Text.Trim([Status2]),
            Replacer.ReplaceText,
            {"Status1"}
        )
in
    RV

hamster.png

[Mohammednt0]

it worked like magic , thanks a lot. u made my day.

[hamster]

You are welcome