Merging columns

M.Lambert
M.Lambert Contributor
edited December 2023 in General

Hi there, I am trying to fix a problem with telephone and mobile columns, the numbers are mixed up in both columns and I already separated them creating other columns, my question is. Can I merge to columns to put all mobile and phone numbers together?

Best Answer

  • M.Lambert
    M.Lambert Contributor
    Answer ✓

    That's great Mirjam, thanks a lot. I will have do some testing here to see what's better, but plenty of options, thanks again!

Answers

  • Mirjam Schuke
    Mirjam Schuke Administrator
    edited May 2023

    Hi M.

    What kind of inputs do you have? If you have only 1 value in either column you can easily merge them into 1 column via the Concatenate function.

    image.png

    which gives you this output:

    image.png

    If you have phone numbers in both columns, using Concatenate you end up with the 2 phone numbers in 1 column. But you can add a separator, like a pipe or a dash. This would get added to all values though, also the single ones.

    image.png

    Another option if you have one value in either column is to use If then else:

    image.png

    which gives you the same output as above. But If then else evaluates in order so it picks the phone number (as it's first) in this case. You would need to determine which column is more valuable/correct than the other.

Categories