Combine two or more cells and transpose in Google Sheets

=TRANSPOSE(SPLIT(TEXTJOIN(",",1,A1:C1),","))

A1:C1 = cell which you want to combine and transpose

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Combine two or more cells and transpose in Google Sheets

Combine two or more cells and transpose in Google Sheets

COMBINE TWO OR MORE CELLS AND TRANSPOSE — GOOGLE SHEETS FORMULA AND EXAMPLE

=TRANSPOSE(SPLIT(TEXTJOIN(",",1,A1:C1),","))

  • A1:C1 = data cell to combine and transpose

  • 1 = ignore_empty, you can use TRUE insisted of 1 as well

  • "," = delimiter, a string, possibly empty, or a reference to a valid string. If empty, the text will simply be concatenated.