Course outline / Power Query
Lesson 59 of 75 · Intermediate · 3 exercises
Power Query: reshaping data
Drop columns you don't need, standardise text and keep only the rows you want.
What you'll practise
- Remove a column you don't need Power Query
- Make country codes capitals Power Query
- Unique UK customers Power Query
Remove a column you don't need
Reports are clearer without internal columns. In Power Query, removing a column is a step, so it happens again automatically next time the data is refreshed.
Choose Internal ID as the column, then click Remove column.
Make country codes capitals
Choose Country as the column, then click UPPERCASE.
Unique UK customers
Steps can be combined. Remove the duplicate row, then keep only the UK customers.
Click Remove duplicates, then choose Country, type uk and click Keep rows equal to.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.