Power Query provides several tools for cleaning columns.

Remove Columns

Select a column:

Home → Remove Columns

Use this when unnecessary fields are imported.

Rename Columns

Right-click the column → Rename

Example:

Cust_Name → Customer Name

Change Data Type

Common data types:

  • Text
  • Whole Number
  • Decimal Number
  • Date
  • Date/Time
  • Currency

Correct data types are important for calculations and analysis.

Remove Duplicates

Select one or more columns:

Home → Remove Rows → Remove Duplicates

Replace Values

Example:

Sirsa → Sirsa

or:

Fatebad → Fatehabad

Use:

Transform → Replace Values

PreviousNext