Shape data

With Microsoft Power Query for Excel, you can shape data from multiple data sources by editing query steps to match your data analysis requirements.

Introduction to Microsoft Power Query for Excel

With the Query Editor, you can navigate, define, and perform data transform operations over a data source.

Import data from external data sources

With Microsoft Power Query for Excel, you can import data into Excel from a wide variety of data sources. You use the Query Editor to shape data by editing query steps.

Shape or transform a query

Shape data from multiple data sources by adding, removing or editing query steps to match your data analysis requirements.

Refresh a query

Refresh a query to import the latest data into a table without having to create the query again.

Combine data from multiple data sources

Combine data from multiple data sources.

Filter a table

Filter a table to reduce the size of your query results by excluding rows or columns based on size, value or condition.

Sort a table

Sort table rows in your query results ranked by a criteria, such as the alphabetical or numerical value of one or multiple columns, and by ascending or descending order.

Group rows in a table 

Group the values in a number of rows into a single value by grouping the rows based upon the values in one or more columns.

Expand a column containing an associated table

Expand a column containing an associated table to reveal the related data. You can extract all column values or selective column values within the related table.

Aggregate data from a column

Aggregate data from any column containing an associated table to reveal the results of a group operation including Sum, Count, Average, Min, and Max.

Insert a custom column into a table

Insert an Index or Custom (you define the formula) column to your current query.

Edit query step settings   

With the Steps pane, you can add, edit, reorder, or delete query steps to change how your data is transformed.

Combine multiple queries    

Combine multiple queries, by merging or appending them. The Merge and Append operations are performed on any query with a tabular shape, independent of the data source that the data comes from.

Merge columns

Merge values in two or more columns in a query.

Remove columns

Remove selected columns or Remove Other Columns from a query.

Remove rows with errors

Remove rows from a query with data errors.

Promote a row to column headers

Promote a row to column headers.

Split a column of text

Split a column of text into multiple columns in two ways: by delimiter or by a number of characters.

Insert a query to the worksheet

Insert data from a query into an Excel worksheet. When you insert data from a query, you can choose to load a query to the Excel Data Model.

 
 
Applies to:
Excel 2013, Power BI for Office 365, Excel 2010