Flip a vertical range into a horizontal one (or vice versa) with a formula.
Copy this formula
=TRANSPOSE(A2:A10)TRANSPOSE turns rows into columns and columns into rows, spilling the result automatically in Excel 365. Unlike Paste Special ▸ Transpose, it stays linked to the source and updates live.
=TRANSPOSE(A2:A10)→spilled rowA column becomes a single row.
In Excel 365 it spills; in older versions select the target range and enter with Ctrl+Shift+Enter.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.