Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to combine with null values

Hello.

 

I have several columns I need to merge, but they have lots of null values. I need to separate them with commas (to get as result a column with several values). I paste an example of what I have and what I get:

 

 

How can I do to skip these null and get as result "Madrid, Cairo", "London, Hanoi", etc, withot these lots of commas and spaces?

 

Thanks,

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , One way is write a manual code  in power query

     

    if [City_europe] <> null then [City_europe] &

    if [City_america] <> null then "," & [City_america]

     

    same way add other using &