Merge all cells to one cell and separate with comma

Question

I use Google Sheets, and I want to get data and create one new cell.

Example:

I have 300 rows and 4 columns, like:

1|3|2|4

5|7|6|8

9|11|10|12

...

297|299|298|300

and one cell that I need in result:

1,3,2,4,5,7,6,8,9,11,10,12...297,299,298,300

player0 · Accepted Answer · 2019-08-17T16:30:33.320

1

=SUBSTITUTE(TRIM(QUERY(TRANSPOSE(QUERY(TRANSPOSE(A2:D),,999^99)),,999^99)), " ", ", ")

______________________________________________________

but if you want just numbers from 1 - 300 in CSV then:

=ARRAYFORMULA(JOIN(", ", ROW(A1:A300)))

edited Aug 17 '19 at 16:30

answered Aug 17 '19 at 16:05

player0

score 1 · Answer 2 · answered Aug 17 '19 at 16:24

1

You could use Textjoin:

=TEXTJOIN(",",1,A2:D)

answered Aug 17 '19 at 16:24

TheMaster