How to convert data from columns to rows in excel?

Asked By Scott Broek 20 points N/A Posted on - 08/04/2012

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?

• Status: Open
• Question Views: 1611
• Answer Count: 3
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #136018

How to convert data from columns to rows in excel?

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.

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.

Now tick the transpose check box and click ok.

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

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/04/2012
• Question Category: MS Excel

Answered By Olyvin 0 points N/A #136019

How to convert data from columns to rows in excel?

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.

About Olyvin

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/04/2012
• Question Category: MS Excel

Answered By czhey 0 points N/A #136020

How to convert data from columns to rows in excel?

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.

About czhey

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/04/2012
• Question Category: MS Excel