Forum Discussion
Advocate IHow to add 2 text columns into one column
Hi guys,
I have 2 columns with text values, which I want to add together into 1 column.
Therefore, I think I need a formula but I can't find it on the forumn.
The first column contains the first names and the second column the surnames.
For example, first column contains a name: John and the second column is its surname: Perrow
I want to add the first name first and then the second name, so it becomes John Perrow.
Could anyone please help?
Best regards,
DSabsi
Option "Merge Columns" is also available on the "Add Column" tab, in which case the original columns will be kept and a new column will be added with the merged values.
6 Replies
InterkoubessSolution Sage
Hi dsabsi,
You can create another column and use the function Concatenate as below ( you can add a spaceas you want):
You can also use power query to do that.
I hope it helps,
Thx.
- MarcelBeug
Community Champion
In the Query Editor, select both columns, go to the "Transform" tab, choose "Merge Columns" and fill out the fields in the popup screen:
dsabsiHi Guys,
I tried both your solutions, and they are almost perfect.
Interkoubess, how do you add space between the two tables, so that it becomes a1 b1?
MarcelBeug, is there also another possibility except for merging, so that i can keep column A(first name) and column B(sur name)? Because with merging, I will lose those 2 tables but the result is very nice!
Many thanks for both of your replies!!!
I look forward to your solutions.
Cheers,
DSabsi
- MarcelBeug
Option "Merge Columns" is also available on the "Add Column" tab, in which case the original columns will be kept and a new column will be added with the merged values.