Forum Discussion

SamWhite's avatar
SamWhite
Frequent Visitor
3 years ago
Solved

Merge values in two columns into new column

I have two columns in excel as shown below:   I want to merge this two columns into a new column using Power Query so that result in the new column called "Final" is like below:   How...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    = Table.AddColumn(PriorStepOrTableName, "Final", each [Req number]?? [Req1 number])

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
3 years ago

= Table.AddColumn(PriorStepOrTableName, "Final", each [Req number]?? [Req1 number])

 

--Nate

SamWhite's avatar
SamWhite
Frequent Visitor
3 years ago

Thanks for the response. It works fine. What does the ?? operator do?