Power Query: clean it once, reuse it forever

Lo que podrás hacer

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.

Paso 1 de 6 · 1 punto

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