Arrow left
Back to product guides
Google Sheets Tips

Switch Rows and Columns in Google Sheets: Explained

In this article, you will learn how to transpose rows and columns by Paste Special in Google Sheets. You can also use the TRANSPOSE function to switch rows and columns. This function is helpful when you want to interchange rows and columns for your data set (e.g., turning a landscape table into a portrait one and vice versa).

How to use the Paste Special to interchange rows and columns

  1. Select a range or an array you want to transpose.
  2. Press “Ctrl”+”C” (for Windows) or “⌘”+“C” (for Mac)  to copy the selected range.
  3. Navigate to a cell from which you want to spread the transposed range.
  4. Right-click → “Paste special” → “Transposed”.

Here is an example. Assume you want to transpose the portrait monthly revenue data for the six months.

Steps 1 to 4

How to navigate to “Transposed” by right-clicking in Google Sheets

Outcome

What a transposed range looks like in Google Sheets

As you can see, all formatting and values of the selected range are copied to a new location. 

So, if you want to copy value only, take the step to transpose everything first. Then copy the transposed range and paste it somewhere else with the “value only” option.

Also, note that the transposed data is not tied to the original data anymore; when you make any changes in the initial data, the changes are not reflected in the transposed range. In this regard, as a transposed range by the TRANSPOSE function is dynamic - linked to the original data source - consider using the function if you want to keep transposed content live.

How do you group and ungroup rows and columns in Google Sheets?

Check this article to learn how to group and ungroup rows and columns.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711