Transposing Rows and Columns in Excel

By June 3, 2019 Tech Tip

What’s transposing in Excel? “To transpose” means to make items change places with each other, or to flip a grid or table such that columns become rows and rows become columns.

This may be a little hard to grasp, but it’s something that you may frequently want to do in Excel: How do you take values in a row and flip them so that those values are stacked in a column? (Or vice versa.) The answer is transposing them. This is how.

Transposing in Excel

Say you have data in rows, like this, and you want these names to be moved into a column.

Tranposing Rows & Columns in Excel

  1. Select and highlight all the values you want to transpose.
  2. Copy the values (Ctrl + C).
  3. Select the cell where you want to insert the values as a column.
  4. Right click and from the menu choose Paste Options > Transpose. If you do not see the Transpose icon, choose Paste Special… > Transpose.Tranposing Rows & Columns in Excel

Then your values will be pasted, but into a column, rather than the original row.

Tranposing Rows & Columns in Excel

You can do the same thing to move a column to a row, or even to flip an entire table, as in this example, where the Y axis becomes the X axis.

Tranposing Rows & Columns in Excel

Transposing may be a little hard to wrap your head around at first (how is the data flipping?), but it can be very helpful in manipulating data once you get the hang of it.


Recent Posts / View All Posts

2019 State of the IT Industry Landscape by OXEN Technology

2019 State of the IT Industry Landscape, Part 5: The Internet of Things and Wireless

| Infrastructure, Leadership | No Comments
In the fifth and final installment of our 2019 update on the state of the IT landscape, we look at two more industry trends: the Internet of Things (IoT) and wireless and wi-fi technologies. What are they, and why is demand increasing? Why is cybersecurity still of constant importance in these areas? Industry Trends: The Internet of Things (IOT) What is the Internet of Things? The IoT is a global network of objects that collect and communicate data via the internet. It extends Internet connectivity beyond laptops, phones, and tablets to an extremely diverse range of “things”. IoT devices include…
2019 State of the IT Industry Landscape by OXEN Technology

2019 State of the IT Industry Landscape, Part 4: The Cloud

| Cloud Solutions, Leadership | No Comments
This is part four of OXEN Technology’s 2019 update on the state of the IT landscape. In the first three parts we covered: the accelerating changes affecting the IT industry, the current economic outlook for the U.S. and the IT industry, and the growing importance of cybersecurity. In this section, we look at the effects of the cloud and cloud computing. Industry Trends: Cloud The future is here. Predictions of rapid adoption of cloud-based applications from only two years ago are already history. Today 91% of businesses claim to be using some sort of cloud computing. (And many small businesses…
Resizing and Cropping Images in Microsoft Paint

How to Resize and Crop Images in Microsoft Paint

| Tech Tip | No Comments
Microsoft Paint is a simple graphics editor included with the Windows operating system. If you need to do some basic image editing, Paint is the perfect lightweight app. In this tech tip, we'll look at two tasks: how to resize an image and how to crop an image. Resizing an Image Open an image in Paint. Right click on the image file and choose Open with > Paint. Choose Resize from the toolbar. In the window that appears, you can resize based on percentage or pixels. Choose which option at the top. Make sure Maintain aspect ratio is selected at…