Merging multiple CSV files into onto one

[gogotofu]

Hello, I'm wondering if it'll be possible to get multiple csv files to be merged together.

Essentially I have a main CSV file with data and several columns that are blank. We have multiple people (5) with the same copy of that CSV filling in those blanks.

When everyone is done their assigned work, I want to be able to merge all those files that will replace all those blank fields from those columns with the values that have been entered and keep everything that was originally in the main csv file.

I hope to make this a macro if possible so that anyone can click on a button when all the files are in one folder, it will produce the merged file

I have attached an image to hopefully make it easier to understand if I'm not clear enough.

 

[alansidman]

Append your files with Power Query.

 

[gogotofu]

Append your files with Power Query.

Hi Alansidman! Thanks for responding me! I did try watching the video but I'm still not sure what to do from here. Sorry, I'm not the not well knowledged in Power Query.

Now that I've tried combining and transforming the data, all the files are merged together so i have duplicate data. What do I do from here?

 

[alansidman]

You have your data in Power Query Editor. At this point, if necessary you can rearrange your data or if you do not need to do that, then close and load to Native Excel.