How to merge 3 files on excel, manage Pivot Data and Slicer

[questforexcel]

Hello All,

I have 3 files have different data formats and fields. There is one common field amongst the 3 reports. The Location ID. The three Files would have different details each of which are connected by the Location ID.

First one, the employee register. Second is the Monthly Costing Analysis. Third is the Fixed Expenses Analysis.

I am looking for guidance on how to merge these 3 excels together. I do not have Power Pivot on my Work MS Office application. It has Power Query though.

After forming a relationship between these 3 files, how do i run slicers to represent data.

Also one area I wanted to know if its possible to filter/edit the details shown from the pivot value field, when I double click it. Whenever I click on the value to get more details, it opens up all the columns and fields for that cost item with all the column fields.

I am trying to attach the file as an example not able to find a tab to attach my file. Could you guide on how to do that.

Thank you,

 

[questforexcel]

Could you please guide on the best way to link and form a relationship between 3 excel files which have different data formats. However, they may have one common field.

Thank you,

 

[jdellasala]

It's been a while, but I suggest posting small samples of the three tables. Note that each table needs a field (column) that has a unique identifier that appears only once in the table, but also appears in one of the other tables. It would be best if all three tables had one identifier that relates to all of them, then even if a table of unique identifiers doesn't exist, it can be built from the other tables.
Please use XL2BB to post the data.