Spreadsheet changing columns to rows (or vice versa)

While working on a Spreadsheet, you might enter information in rows and rather regret as it should have been Columns or vice-versa. You will have tens or even hundreds of rows that need to be converted into columns. Transforming that manually will be a tedious and time consuming process. It is explained below on how to do it easily with different Spreadsheet Software(online/offline)

Excel Rotate data by converting columns to rows (or vice versa)

  1. Copy the data in one or more columns or rows.
  2. Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special.
  3. In the Paste Special dialog box, select Transpose, and then click OK.
  4. You’ll find the Transpose check box in the lower-right corner of the dialog box:
The Paste Special dialog box

The Paste Special dialog box

5. Starting with your first cell, Excel pastes the data into a row or column.

Check out more about it at Microsoft Office SupportRotate data by converting columns to rows (or vice versa)

Google Spreadsheet converting columns to rows (or vice versa) Transpose Function:

As I have noted earlier, Google Spreadsheet is a best alternative for MS Excel and has its own advantages. Below are the steps:

  1. Go to the sheet where you want the data to be transposed
  2. Click on a cell from where you want the new set of data to start
  3. Type ‘=TRANSPOSE(‘
Google Spreadsheet Transpose Function

Click image for better clarity

4. Choose the range of cells that you want to convert
5. Press Enter

Google Spreadsheet Transpose Done

Click image for better clarity

OpenOffice Calc Rotate data by converting columns to rows (or vice versa)

This works similar to MS Excel.

  1. Go to the sheet where you want the data to be transposed
  2. Choose the range of cells that you want to convert
  3. Press Key Combination CTRL + X to cut the data
  4. Click on a cell from where you want the new set of data to start
  5. Click Edit and select Paste Special.
  6. In the Paste Special Dialog Box, check the Transpose checkbox.
  7. Click OK and it is done.

Below are other common Spreadsheet software listed:

These work in a similar way to MS Excel spreadsheet as well.

Kingsoft Office Spreadsheet – How to Convert a Column to a Row in Kingsoft Spreadsheets

LibreOffice Calc – Rotating Tables (Transposing)

Do you have a spreadsheet that is used common for which you need tips? Post your questions as comments below. Also your feedback are highly appreciated.

Advertisements

One thought on “Spreadsheet changing columns to rows (or vice versa)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s