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.

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 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.

When you use the Microsoft Excel products listed at the bottom of this article, you can use a worksheet formula to covert data that spans multiple rows and columns to a database format …

Power Query splits the Sales Rep names into two different columns named "Sales Rep 1" and "Sales Rep 2". To change the default names, rename them to "Sales Rep First" and "Sales …

Select the cell, range, or entire column that contains the text values that you want to split. On the Data tab, in the Data Tools group, select Split Text to Columns. Select the delimiters that you …

To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed.

You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.

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 …

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to …