Forum Discussion
dsabsi
Advocate I
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...
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.
Interkoubess
Solution Sage
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
Community ChampionIn the Query Editor, select both columns, go to the "Transform" tab, choose "Merge Columns" and fill out the fields in the popup screen: