Merging Files and Grouping by several variables

I don't see how we can give you a detailed answer without knowing the structure of the three files.
Are you able to load the files, even as unmerged ?
if so can you make a reprex from the 3 ?
Please have a look at this guide, to see how to create one: