How to Concatonate several columns.

[mayork]

Hello,

I want to create a new colomn that concatonates three colomns into one key.  eg. I want Month, name and vrg to be in a field beside this that says JAN5 GUYS CSD 500ml PET.  What is the simpletst way to do that?

Months	NAME	VRG	Months Order
JAN	5 GUYS	CSD 500ml PET	M01 JAN
JAN	5 GUYS	DAS  591ml	M01 JAN
JAN	5 GUYS	NT 500ml	M01 JAN
JAN	5 GUYS	Postmix Jc BIB 10L	M01 JAN
JAN	5 GUYS	Postmix Jc BIB 20L	M01 JAN
JAN	5 GUYS	Postmix Spk BIB 10L	M01 JAN
JAN	5 GUYS	Postmix Spk BIB 20L	M01 JAN

[AllisonKennedy · Accepted solution]

I would recommend using Power Query to do this. Select each column in order you want them concatenated, then click Merge columns on the Add Column tab in Power Query Editor.

[LeandroCampacci · Accepted solution]

The best way for this, is using Power Query (select columns -> tab Add Column -> Merge OR select columns, right click on then and "merge").

Also, if you want to do this on a calculated column (less performance), create a new column using DAX expression CONCATENATE. 

Your Column = CONCATENATE('Table'[Column 1], 'Table'[Column 2]...)

Remember: Power Query is the recomended away to do this. 🙂

[AllisonKennedy · Accepted solution]

I would recommend using Power Query to do this. Select each column in order you want them concatenated, then click Merge columns on the Add Column tab in Power Query Editor.