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 …

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.

Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Pick a spot in the worksheet that has enough room to paste your data.

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.

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 …

Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.

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.

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 perform transformation and aggregation steps, and combine data from both sources to produce a Total Sales per Product and Year report. In order to perform this tutorial, you need the Products and …

Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.