power query - apply transformation/cleaning of one query to the next query.

[heathball]

I think i am missing something very simple. I cannot understand why I am at this point and cannot proceed.
I am learning power query.
Lots of transformation/cleaning etc has been applied to files that have come from a web query, so i have 3 queries (R1,R2, and merge1) - did it 4 hours ago.
I had 2 originals, and then i created a merged query.

I have a 2 new files- 2 new queries - (R4,R5, and i am looking to create the same merged), and it is the same raw structure as (R1,R2), columns, etc....exactly the same beginning point. It needs the same process.
But i am not at the merge stage yet with the 2nd set of files.

I want to automatically apply the tasks i did 4 hours ago to these two new files so they.. transform....without going through the same steps of doing it myself..i am assuming this is one of the features of PQ.
I have tried various things. All the options I see on the menus are not pointing me anywhere helpful. I know there is a little bit of X-Twitter negativity ATM, but mine is towards Google and You Tube, until I find out it that it should be self-directed.

Have not been able to find out how to achieve this. It is not trauma, but I'm on the back foot from the whole experience. I was assuming there was a clear option for this.

I would dearly appreciate any assistance.

 

[ExcelToDAX]

Can you give me some sample code of the first two tables? You would essentially create a Power Query Function and have it do the same steps for as many tables as you want.

 

[heathball]

Thanks ExcelToDAX. I am working through it.