Need some help on my excel

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

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?

SHARE
Best Answer by Niley Samilene
Best Answer
Best Answer
Answered By 0 points N/A #163200

Need some help on my excel

qa-featured

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.

Answered By 0 points N/A #163201

Need some help on my excel

qa-featured

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

Answered By 0 points N/A #163202

Need some help on my excel

qa-featured

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

Answered By 0 points N/A #163203

Need some help on my excel

qa-featured

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

 

Answered By 0 points N/A #163204

Need some help on my excel

qa-featured

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.

Login/Register to Answer

Related Questions