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.

With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways …

You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function. For …

Select the Date column, select Home > Transform > Data Type, and then select the Date option. You can convert other numeric types, such as percentage or currency.

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 …

You can use Transform Data to shape your data with the Power Query Editor, or Load to load the data to the Excel grid. For more information about Power Query in Excel, see Power Query for Excel Help.

You can use Excel's Get & Transform (Power Query) experience to connect to multiple data sources, then use the Query Editor to shape and transform data.

With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how.

There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and …

Learn how to format your data in Excel so that you can use Copilot to get insights, generate formulas for new columns, and highlight, sort, and filter your data.