Need some help on my excel

Asked By Brayen Jones 0 points N/A Posted on - 08/29/2012

Hello,

I need some help on my excel spread sheet.

I have 10 columns.

I have to transfer these as 10 rows.

Is there any way to do this?

• Status: Open
• Question Views: 894
• Answer Count: 5
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Microsoft Others

Best Answer by Niley Samilene

Go To Solution

Best Answer

Best Answer

Answered By Niley Samilene 0 points N/A #163200

Need some help on my excel

Hi,

Yes, it is possible.

 At first, you have to copy the columns.

Then, go to another excel sheet, select a cell, click the right button and select the “paste special” option.

Now, give tick marks on the ‘Skip blanks’ and ‘Transpose’ options. Click Ok.

By doing this process you can transfer all columns in rows at a time.

About Niley Samilene

Questions
2

Answers
92

Best Answers
17

• Vote Up 0 Vote Down

• Posted on - 08/29/2012
• Question Category: Microsoft Others

Answered By jerrus123 0 points N/A #163201

Need some help on my excel

Hi,

To convert a file from column to row. Please follow these steps.

First, copy all the information that you want to convert.

Second, go to any available column, just right click and select "paste special".

Third, check "Transpose" then "OK".

Last, highlight again the files you copied earlier. Instead of copying it again, right click then select "Delete".

Just delete the entire column.

Best Regards,

Jerameel Cyrus Tubon

About jerrus123

Questions
0

Answers
6

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/30/2012
• Question Category: Microsoft Others

Answered By sumon_ach 0 points N/A #163202

Need some help on my excel

Hi, Brayen Jones,

I think your problem is solution able, make the copy of your columns, open another excel sheet, then click in the right button of the excel sheet then you have to click on the paste special option, that it!

You can also search in the Google or Windows live search for better solutions.

Best Regards, Sumon Khan

About sumon_ach

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/30/2012
• Question Category: Microsoft Others

Answered By Carl Jack 10 points N/A #163203

Need some help on my excel

Hello Brayen,

To transfer the data between columns and rows, you will need to follow the procedure that follows:

• First of all, you will need to copy the data in one or more columns.
• Before you proceed to paste the copied data, you will need to right-click your first destination cell which is the first cell of the row into which you want to paste your data, and then after that you will click Paste Special.
• In the Paste Special dialog box,  you will need to choose  Transpose, and then click OK.
• The Transpose check box is in the lower-right corner of the dialog box.
• From your first cell, Excel will paste the data into a row or column.

Regards,

Carl

 

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/30/2012
• Question Category: Microsoft Others

Answered By pincraft12 0 points N/A #163204

Need some help on my excel

Hi, 

I read your question.

Your solution is at first select you 10 columns and then copy it and then go other sheet then click paste special and then check transpose and click ok.

About pincraft12

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/08/2012
• Question Category: Microsoft Others