Question

Which command will you choose to convert a column of data into row?
A.Cut and Paste
B.Edit >> Paste Special >> Transpose
C.Both of above
D.None of above

Answer 1

B) Edit >>paste special >>transpose is correct answer

Answer 2

Answer:

B. Edit >> Paste Special >> Transpose

Edit >> Paste Special >> Transpose command will you choose to convert a column of data into row.

Explanation:

Ctrl + C will copy the selected cells. G10 is the cell where you want to copy this data set. When you press Alt + E + S, a paste special dialog box popup window appears, in which you can select or click on the Transpose option, which will result in or convert column data to rows data in Excel.

Steps to convert a column of data into row:

Step 1: Choose blank cells. First, choose some empty cells....

Step 2: While those blank cells are still selected, type =TRANSPOSE

Step 3: Enter the original cell range. Now enter the range of cells you want to transpose.

Step 4: At the end, press CTRL+SHIFT+ENTER.