Splitting rows and moving to csv lines in Excel

Question

I have data looking like this:

John
1231231234
john@email.com
Bob
1241241244
bob@email.com

I would like to have it look like this

john, 1231231234, john@email.com
Bob, 1241241244, bob@email.com

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),"")