Splitting rows and moving to csv lines in Excel

Question

I have data looking like this:

John
1231231234
[email protected]
Bob
1241241244
[email protected]

I would like to have it look like this

john, 1231231234, [email protected]
Bob, 1241241244, [email protected]

What's the easiest way to do so in Excel?

question from:https://stackoverflow.com/questions/65602552/splitting-rows-and-moving-to-csv-lines-in-excel

Answer 1

Note this assumes 3 cells per as a pattern:

Office 365/2019:

=TEXTJOIN(", ",TRUE,INDEX(A:A,(ROW($ZZ1)-1)*3+1):INDEX(A:A,(ROW($ZZ1)-1)*3+3))

Older:

=IF(INDEX(A:A,(ROW($ZZ1)-1)*3+1)<>"",INDEX(A:A,(ROW($ZZ1)-1)*3+1) & ", " & INDEX(A:A,(ROW($ZZ1)-1)*3+2) & ", " & INDEX(A:A,(ROW($ZZ1)-1)*3+3),"")