Power Query: clean it once, reuse it forever

Ce que vous saurez faire

Import a raw export, shape it in the query editor, and refresh next month's file without repeating any of the work.

Flash Fill cleans this month's file. A formula cleans this month's file faster. Power Query cleans every file you will ever receive in this shape, because it remembers what you did.

Étape 1 sur 6 · 1 point

Import the raw sales export into the workbook as a query, without loading it to a sheet yet.