If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows.

You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns.

The following example converts every four rows of data in a column to four columns of data in a single row (similar to a database field and record layout). This is a similar scenario as that …

Column F is the new column. In one of the cells of the new column, type =VALUE () and inside the parentheses, type a cell reference that contains text stored as numbers.

Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table: Click …

On the Data tab, in the Data Tools group, select Text to Columns. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into separate …

On the Layout tab, in the Data section, click Convert to Text. In the Convert to Text box, under Separate text with, click the separator character you want to use in place of the column …

How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.