Transpose row to column and ignore blank in Excel and Google Sheets

{=TRANSPOSE(FILTER(A2:A6, A2:A6<>""))} // ignore blanks

{=TRANSPOSE(A2:A3)} // doesn't ignore blanks

A2 = data cell

ArrayFormula use "Ctrl+Shift+Enter" for both formulas

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

Transpose row to column and ignore blank in Excel

How to transpose row to column and ignore blank in Excel?
Transpose row to column and ignore blank in Excel

TRANSPOSE ROW TO COLUMN AND IGNORE BLANK — EXCEL FORMULA AND EXAMPLE

{=TRANSPOSE(FILTER(A2:A6, A2:A6<>""))} // ignore blanks

{=TRANSPOSE(A2:A3)} // doesn't ignore blanks

💡 ArrayFormula use "Ctrl+Shift+Enter" for both formulas

Transpose row to column and ignore blank in Google Sheets

How to transpose row to column and ignore blank in Google Sheets?
Transpose row to column and ignore blank in Google Sheets

TRANSPOSE ROW TO COLUMN AND IGNORE BLANK — GOOGLE SHEETS FORMULA AND EXAMPLE

=TRANSPOSE(FILTER(A2:A6, A2:A6<>"")) // ignore blanks

=TRANSPOSE(A2:A3) // doesn't ignore blanks