Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






How to remove columns in Power Query Editor ?

How to remove columns in Power Query Editor

Introduction to Power Query

Power Query is a data transforming engine which you can use to get data from multiple sources, clean and transform that data and then use it further in the analysis.

Remove Columns in Power Query

Let’s say you got data from somewhere and you need to delete some columns from it. The thing is, you have to delete those columns every time you add new data, right? But, power query can take care of this.

  • Select the column or multiple columns that you want to delete.

Remove Column 1

  • Now, right-click and select “Remove”.

Quick Tip: There’s also an option to “Remove Other Columns” where you can delete all the unselected columns.

Other Examples of Power Query tool in MS Excel 

Below is the list of examples of using Power Query tool in MS Excel, you can learn and master each examples –

Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes