Transform a Column to a String

%3CLINGO-SUB%20id%3D%22lingo-sub-1858075%22%20slang%3D%22en-US%22%3ETransform%20a%20Column%20to%20a%20String%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858075%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20(Google%20Sheets)%3C%2FP%3E%3CP%3E1.%20How%20to%20convert%20column%20to%20string%3F%3CBR%20%2F%3E2.%20How%20to%20transform%20the%20column%20(or%20row)%20by%20putting%20after%20each%20element%20one%20more%20element%20with%20the%20specific%20constant%20content%3F%20For%20example%2C%20replace%3CBR%20%2F%3Ea%2C%20b%2C%20c%2C%20d%2C%20e%2C%20f%3CBR%20%2F%3Eon%20to%3CBR%20%2F%3Ea%2C%20x%2C%20b%2C%20x%2C%20c%2C%20x%2C%20d%2C%20x%2C%20e%2C%20x%2C%20f%2C%20x%2C%3CBR%20%2F%3E3.%20How%20to%20unite%20two%20adjacent%20columns%20into%20one%20column%20in%20the%20following%20element%20order%3A%20a1%2C%20b1%2C%20a2%2C%20b2%2C%20a3%2C%20b3%2C%20...%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1858075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1858235%22%20slang%3D%22en-US%22%3ERe%3A%20Transform%20a%20Column%20to%20a%20String%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F859107%22%20target%3D%22_blank%22%3E%40vznamenskiy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20became%20straightforward%20with%20the%20introduction%20of%20the%20TEXTJOIN%20function.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%20TEXTJOIN(%22%2C%22%2C%201%2Ccolumn)%0A%0AFor%20a%20string%20%22x%22%0A%3D%20TEXTJOIN(%22%2C%20%22%2C%201%2Ccolumn%26amp%3B%22%2C%20x%22)%0Aor%20a%20cell%20reference%0A%3D%20TEXTJOIN(%22%2C%20%22%2C%201%2Ccolumn%20%26amp%3B%20%22%2C%20%22%20%26amp%3B%20x)%0A%0AFor%20two%20columns%20of%20data%0A%3D%20TEXTJOIN(%22%2C%22%2C%201%2C%20data)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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, replace
a, b, c, d, e, f
on to
a, x, b, x, c, x, d, x, e, x, f, x,
3. How to unite two adjacent columns into one column in the following element order: a1, b1, a2, b2, a3, b3, ...?

2 Replies
Highlighted

@vznamenskiy 

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)
Highlighted

@Peter Bartholomew 

For #2 it could be

=TEXTJOIN("x, ",1,1Drange)