Forum Discussion
Transform a Column to a String
Excel (Google Sheets) 1. How to convert column to string? 2. How to transform the column (or row) by putting after each element one more element with the specific constant content? For example, rep...
This became straightforward with the introduction of the TEXTJOIN function.
= TEXTJOIN(",", 1,column)
For a string "x"
= TEXTJOIN(", ", 1,column&", x")
or a cell reference
= TEXTJOIN(", ", 1,column & ", " & x)
For two columns of data
= TEXTJOIN(",", 1, data)