Hello!
Can someone please tell me how to combine two different columns into one? I've got some data with two possible addresses. There are no duplicates between address A or address B. I just need a clean column that shows an address (whether it's A or B). The addresses have numbers and letters which need to be preserved. Did I input the formula correct below?
If not, how can I do this?
Solved! Go to Solution.
Hi @skeen503979,
I have made two solutions for you but I believe the first one will suit your needs:
Thanks @Emil_Kos. The first solution (where you just add "+" instead of "and") worked great.
Thx!