Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combining Two Columns into One

Hey guys, I've got two seperate columns containing "hour registration codes". These two columns should be transformed into one. If Column A (Ontvanger) is Null, the code is available in Column B...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Concatenate",each List.RemoveItems({[Column A],[Column B]},{"",null}){0}?)

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

NewStep=Table.AddColumn(PreviousStepName,"Concatenate",each List.RemoveItems({[Column A],[Column B]},{"",null}){0}?)