medium10 pts · first answer countsexceldata-cleaningautomation

Same cleaning every Monday

Every Monday you get a CSV export and spend an hour removing blank rows, splitting a name column and fixing date formats in Excel. What is the best improvement?

A.Record the steps in a notebook and repeat them by handB.Ask the source team to send the data as a PDFC.Do the cleaning only once a month to save timeD.Build the steps once in Power Query so each new file is cleaned by a refresh

Discussion 0

Join free to post in the discussion.

Same cleaning every Monday

Discussion 0

Related questions