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] ...
Go to Solution.
I would use:
[Column1] & [Column2] & [Column3]...
Proud to be a Datanaut!
@Bigrover Then, please use separators in between concatination.
Table[Col1] & "," & Table[Col2]
Proud to be a Datanaut !
Thanks! If I wanted to seperate by a space or comma, how would I do that?