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.

You can use a worksheet formula to covert data that spans multiple rows and columns to a database format (columnar).

If you see the alert: Select the cells you want to convert, and then select the error notification . Select Convert to Number from the menu. You will see the values left aligned and green triangle warning …

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

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

Combine data in Excel using the CONCAT function Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells …

In some scenarios, you don't have to convert numbers stored as text back to numbers, as described earlier in this article. Instead, you can just apply a number format to achieve the same result.

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.