Forum Discussion
Advocate IHow to add 2 text columns into one column
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.
Solution SageHi 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.
- dsabsi
MarcelBeug, thank you very much, I used your solution and it works perfectly!!