How to convert data from columns to rows in excel?

Asked By 20 points N/A Posted on -
qa-featured

I receive excel sheets from many branches of a company. I want to make a schedule from those sheets. There are about hundred columns and thousand rows of data in a table. I want change that table by converting columns to rows. How can I do it in excel easily using an option?

SHARE
Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #136018

How to convert data from columns to rows in excel?

qa-featured

You are able to do your work through a Microsoft excel option. This can be done using the transpose option which is in special paste.

I will explain it using an example. Please see the image below.

Special Pasting options

Now what I want is those headings which are in columns to show in rows. That means heading is as follows.

In cell A1              – Month

In cell A2              – Item Quantity

In cell A3              – payments

And the corresponding data should be displayed Row A, B & C.

Select the entire set of data and copy. Go to another blank sheet and click on the Cell A1.

Then right click and click on the paste special.

Special Paste options

Now tick the transpose check box and click ok.

Paste Special

Now you can see that all the data has been converted as you expected.

Data has been coverted
Answered By 0 points N/A #136019

How to convert data from columns to rows in excel?

qa-featured

Use the transpose function in excel. That should help you out. Select the data, copy the data and go to edit, paste special and select the transpose option. Your data will be transposed.

Thank you.

Answered By 0 points N/A #136020

How to convert data from columns to rows in excel?

qa-featured

Instead of moving the data manually, you can use an option of the Paste Special command as follows:

  1. Select the data in the column.
  2. Right click and then select copy.
  3. Select the first cell in the destination row.
  4. Right click and then select paste special.
  5. The paste special dialog box will open.
  6. In the lower right corner select the check box labeled “transpose” and click OK.
  7. Your data will be transposed into a row.

Related Questions