Concatenate 6 columns into 1

[Anonymous]

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?

[Greg_Deckler · Accepted solution]

I would use:

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

[Greg_Deckler · Accepted solution]

I would use:

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

[Anonymous]

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

[PattemManohar · Accepted solution]

@Anonymous Then, please use separators in between concatination.

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