Power Query: clean it once, reuse it forever

Was du danach kannst

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.

Schritt 1 von 6 · 1 Punkt

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