| Column A | Column B |
|---|---|
| 2 | 4 |
| 1 | 9 |
If I had a google sheets doc that looked something like this, how do I put them all into 1 line like “2 4 1 9”.
I am new to google sheets and I know barely anything about it and would just like a method to do this if possible.
You just need TEXTJOIN(). Try-
<code>=TEXTJOIN(" ",1,A1:B2)
</code>
<code>=TEXTJOIN(" ",1,A1:B2)
</code>
=TEXTJOIN(" ",1,A1:B2)