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 between)

B                 B              B B (space between)

C                                 C (without space at the end)

D                                 D (without space at the end)

E                 E               E E (space between)

 

I',m going to do this on Street name, street number and street letter. There is a lot of addresses without street letter, but I dont want to have the space at end on the street name + street number without street letter in the tables (null)

 

 

Regards
Marius

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion

    Anonymous 

     

    You can use this custom column

     

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