Combine Data

[Anonymous]

Hi All,

I have 4 excel files:

1: Employee Listing: Names and employee IDs of all company employees

3x - Surveys: Names and IDs of employees wokring in a department. Table also includes a column for all of that department's projects and the percentage of the persons time each employee spend on each project. Note: some employees may appear in more than one of these 3 files.

I want to connect to a folder to pull the 4 files in and combine the data to provide the employee listing and show a column for all of the projects on the survey and the total percentage of the persons time spend on each project. 

I would like to be able to run this on the data for the current period then be able to simply connect to a new folder for the data in the subesqent period and be able to have the same work flow be ran.

How would I do this?

Thanks in Advance!!

B 

[lbendlin]

Sounds like standard Power Query. What have you tried and where are you stuck?

What kind of folder is it?  It is not recommended to do this with folders on your PC.  Place the files on a OneDrive or SharePoint folder for easier processing, and to avoid the need for a gateway.