Solved: Merge values in two columns into new column

SamWhite · ‎04-27-2023

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?

watkinnc · ‎04-27-2023

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

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

watkinnc · ‎04-27-2023

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

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

SamWhite · ‎04-27-2023

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

Merge values in two columns into new column

Helpful resources

Microsoft Fabric & AI Learning Hackathon