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 can i acheive this using power query?

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

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

     

    --Nate

2 Replies

  • 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?