How to add 2 text columns into one column

[dsabsi]

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

[Interkoubess]

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.

[dsabsi]

Hi 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 · Accepted solution]

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.

[tghimire]

Hi @MarcelBeug,

Is it possible to merge 2 columns in Measures? We use live connection and I do not have rights to change anything in the data model. I want to concatenate 3 columns and show them in one in matrix or table visual. Any help will be appreciated.

regards

tanuj

[dsabsi]

@MarcelBeug, thank you very much, I used your solution and it works perfectly!! 

[MarcelBeug]

In the Query Editor, select both columns, go to the "Transform" tab, choose "Merge Columns" and fill out the fields in the popup screen: