Module 03 · Clean it in Power Query

Tidy up vendor names

Make vendor spellings consistent with Trim, Clean and Capitalize Each Word.

Step by step6 minLesson 12 of 37 Members

One vendor can be written in several ways: PT MITRA OFFICE, pt mitra office and " PT Mitra Office" with leading spaces. To a person that’s the same vendor; to Power Query those are three different texts, and the one with leading spaces shows up as a separate vendor in a PivotTable or chart, splitting its amount. In this lesson you make them all consistent with three options in the Format menu.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

5 steps with a numbered picture
All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
A new Excel & dashboard template every day, with resell rights
Take paid client projects on the Project Board

Become a member & unlock all Already a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons