When a row of data is to be converted into columns
When a row of data is to be converted into columns Correct Answer Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK
Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > TransposeSelect the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK