Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Merge two columns in Power Query (M)

Hi all,   Anyone knows howto merge two columns in Power Query with space as delimiter but not on the blank values? Ex: Column1    Column2  Merge A                 A             A A (space betw...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    You can use this custom column

     

    =Text.Trim([Column1]& " "&[Column2])
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous 

 

You can use this custom column

 

=Text.Trim([Column1]& " "&[Column2])