cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bigrover Frequent Visitor
Frequent Visitor

Concatenate 6 columns into 1

I am trying to concatenate 6 columns into one. I am running into issues with the formula and getting it to work. 

 

I am trying to type in = CONCATENATE([column1], CONCATENATE([column2] ...

 

Any thoughts?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Concatenate 6 columns into 1

I would use:

 

[Column1] & [Column2] & [Column3]...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Concatenate 6 columns into 1

@Bigrover Then, please use separators in between concatination.

 

Table[Col1] & "," & Table[Col2]


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





3 REPLIES 3
Super User
Super User

Re: Concatenate 6 columns into 1

I would use:

 

[Column1] & [Column2] & [Column3]...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Bigrover Frequent Visitor
Frequent Visitor

Re: Concatenate 6 columns into 1

Thanks! If I wanted to seperate by a space or comma, how would I do that?

Super User
Super User

Re: Concatenate 6 columns into 1

@Bigrover Then, please use separators in between concatination.

 

Table[Col1] & "," & Table[Col2]


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !