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 (columnar).

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 Text to Columns. Follow the instructions in the Convert Text to …

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 (columnar).

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 Rep Last".

Returns a calculated array of a specified row and column size, by applying a LAMBDA function

If you choose not to use your own headers, Excel will add default header names, like Column1, Column2 and so on, but you can change those at any time. Be aware that if you have a header row …

In the Convert to Text box, under Separate text with, click the separator character you want to use in place of the column boundaries. Rows will be separated by paragraph marks.