How to copy horizontal data and paste it vertically in Excel (or vice versa)
In Excel, rearranging data from rows to columns or vice versa is a common requirement, especially when preparing data for reports or adjusting the layout for analysis. This guide explores efficient ways to transpose data horizontally and vertically using Excel's built-in Transpose feature and Kutools for Excel. These methods streamline the process of reorienting your data, saving time and reducing manual-entry errors.
| Method | Best for | Key advantage |
|---|---|---|
| Excel Transpose feature | Switching a copied row to a column or a copied column to a row | Built into Excel and quick for a straightforward one-time transpose |
| Kutools for Excel | Transforming a row, column, or multi-cell range into a different layout | Provides several transformation types in one dialog box |
Copy horizontal data and paste it vertically (or vice versa) with the Transpose feature
The Transpose feature in Excel allows you to switch the orientation of your data from rows to columns or columns to rows without changing the data itself.
- Select the horizontal data, right-click and choose Copy from the context menu, or press Ctrl + C to copy it.
- Select the first cell of the destination column, right-click, and select Transpose (T) in the Paste Options section of the shortcut menu.
The selected horizontal data is now pasted vertically.
📝 Note:
The Paste Transpose feature also works in the opposite direction, from vertical to horizontal.
Transpose data between horizontal and vertical orientations with Kutools for Excel
Kutools for Excel offers several options for transposing data to suit different transformation needs. Whether you need to switch rows to columns or transform a multi-cell range into a single row or column, its Transform Range feature makes the process straightforward.
- Select the data range you want to transform, and click Kutools > Range > Transform Range.
- In the Transform Range dialog box, select the required option in the Transform type section, and click OK.
- In the next Transform Range dialog box, select a cell for the results, and click OK.
The selected range is transformed according to the option you specified. The screenshot below shows a selected range transformed into a single vertical column.
Kutools for Excel - Supercharge Excel with over 300 essential tools, making your work faster and easier, and take advantage of AI features for smarter data processing and productivity. Get It Now
By mastering these techniques to copy horizontal data and paste it vertically—or the reverse—you can improve how you manage and present data in Excel. For more practical Excel tutorials, discover more Excel tips and tricks here.
Frequently asked questions
Does the pasted data stay linked to the original data?
No. Paste Transpose creates a separate copy, so later changes to the source are not reflected in the transposed result.
Can I transpose formulas as well as values?
Yes. Excel can transpose copied formulas, but relative cell references may adjust in the destination. Check the results to ensure the references still point to the intended cells.
Why is the Transpose option unavailable?
Make sure you copied the source range rather than cut it. Also ensure the destination is not inside the copied range and that merged cells are not preventing the paste.
Will transposing overwrite existing cells?
It can. Before pasting, make sure the entire destination area is empty or contains data you no longer need.
Which Kutools Transform Range option should I choose?
Choose the option that matches the required output: range to single row, range to single column, single row to range, or single column to range.
Video: Copy horizontal data and paste it vertically (or vice versa) in Excel
Related articles
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in