Excel Power Query
Excel Power Query is a table transformation engine built into Excel.
Contents
Usage
To create a table for the Power Query editor to work on, see Get and Transform Data.
With the editor open on a table, a series of basic tools are available from the Home Ribbon:
Close & Load exits the editor and imports the table into the Excel workbook as a new sheet.
Choose Columns and Remove Columns subset the table column-wise
Keep Rows and Remove Rows subset the table row-wise