Power Query combine txt files from a folder/folders

[Van1960]

I have one file that contains legacy data (C:\Accounting\Legacy Data). I want to add them to each file in the folder (C:\Accounting\Data Source) first then combine them into one file. I can combine files from a folder but to add data to each of them first then combine them that gives me problem. I appreciate your help, please see attached files/folder.

Thank you,
Van

 

[p45cal]

Try refreshing the table in the attached.
It uses the 20101231.txt file by name, expecting to see it in C:\Accountancy\Legacy Data
and whatever files (ie all files) it finds in C:\Accountancy\Data Source (this could be refined to specific types of file if necessary).
This does not change any of the source files.

 

[Van1960]

It works perfectly!

Thank you so much!,
Van