Forum Discussion
Solved
How to combine three columns into one?
Hi, I have a table that has three columns (Zip codes columns). I want to combine all of them into one column that has all the zip codes. How can I do that?
CONCATENATE([col1],CONCATENATE([col2],[col3]))
Anonymous
The problem with this is that it combines them on the same line, which is not what I want. Your code would make the the new list looks like this
However, I want the new list to look like this