Question

Which command will you use to convert a column of data into row?

Answer 1

te: If your data is in an Excel table, the Transpose feature won't be available. You can convert the table to a range first, or you can use theTRANSPOSE function to rotate the rows and columns.

Here's how to do it: Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.