= Excel Power Query = '''Excel Power Query''' is a table transformation engine built into Excel. <> ---- == Usage == To create a table for the Power Query editor to work on, see [[Excel/GetAndTransformData|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 ---- CategoryRicottone