• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Excel Tutorials

Microsoft Excel Tutorials

  • Home
  • Tutorials
  • Learn
    • Formulas
    • Power Query
    • Errors
    • Videos
    • Charts
    • Shortcuts
    • Pivot Tables
    • Macros
    • Basics
    • Analysis
  • 240+ Excel Shortcuts
  • Privacy Policy
You are here: Home / Power BI / Power Query / How to Remove Columns Using Power Query?
How to Remove Columns Using Power Query?

How to Remove Columns Using Power Query?

posted on October 1, 2019

Remove Columns Using Power Query or Get & Transform

Excel in 2016 has a new set of features known as Get & Transform which was known as Power Query in Excel version 2010. It provides you with a platform to perform a series of steps to help you to transform your Excel data. There is one step which will help you to remove columns easily. Sometimes you must want to remove some existing columns which you don’t want to see in your final report but also want to keep it in your source data, but you don’t know how to do it so, this tutorial will be helpful for same. 

Previously in Power Query: How to Duplicate Columns Using Power Query or Get & Transform?

For this tutorial, I have the following source data given below. Now you will be seeing that the marked column is the one I need to remove to show you as an example. 

Remove Columns Using Power Query

STEP1: Insert TABLE

First you need to turn you selected data into an Excel Table by pressing this shortcut Ctrl + T or by going to Insert > Table.

Duplicate Columns Remove Columns Using Power Query

STEP 2: Open Power Query

If you are using Excel 2016:

Go to Data > From Table (Under Get & Transform)

Remove Columns Using Power Query

Or if you are using Excel 2013 & 2010:

Power Query > Excel Data > From Table

STEP 3: Removing Column Using Power Query

After following them you will see an open Power Query Editor on your screen.

Now hold the CTRL key to select the multiple columns if you need to remove multiple columns or if you need to remove only one column then select that column. After selecting the column(s) follow this procedure:

Go to Home > Manage Columns > Remove Columns > Remove Columns

Remove Columns Using Power Query

Now to open a new worksheet in your Excel workbook with the cleaned table, Click Close & Load from the Home tab. 

Remove Columns Using Power Query

Filed Under: Power Query Tagged With: Power Query, Remove Columns, Remove Columns Using Power Query

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Download 240+ Shortcuts

Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Categories

  • Basics
  • Formulas
  • Pivot Tables
  • Charts
  • Power BI
  • Analysis
  • Shortcuts
  • Macros
  • Add-Ins

Recent Comments

  • Olivia on Convert Formulas to Values in Excel
  • Pkv on How to Insert Comment In Power Query Steps?
  • Rahul on How to Insert Comment In Power Query Steps?
  • David on How to Insert Comment In Power Query Steps?
  • sofia on How to use Workday Formula in Excel?

Footer CTA

Get Weekly Updates in your mailbox

Get Started Now

Copyright © 2021