I have loaded a data set and applied over 40 steps to clean the data into the right format before I load it to a pivot table.

Every month I will receive a new raw data set in the same format that these same cleaning steps will need to be applied to.

How do I save the query steps and apply them to a new data set. Eg. I will have to load a difference set of data and then clean it. I don't want multiple queries in the same file as they will need to be converted to their own set of pivot tables for each individual client.

Apologies in advance if this has been answered.  I couldn't find anything on the forum and I have gone through Section 5.06 in the Power Query course a couple of times but it didn't seem to address how you add the existing steps to a new set of data.

Thank you for your help!

Anita.