Data Model PivotTable

[happyhungarian]

Hi, I'd like to utilize the Data Model within Excel but the issue I'm running into is that both of the data sets that I'd like to combine have duplicate values for each of the fields I'm trying to match. Essentially I have two lists of expenses by vendor and account. On each list the vendor name and account number can show up multiple times in various combinations. Therefore I wont have one unique value for the vendor or account. Is there a method instead of the Data Model that could easily combine these worksheets/tables into one?

Thanks,

Jesse

 

[SpillerBD]

For when you are cross referencing the two tables, you need a third table that has just the single occurrences. This Table becomes a middleman between the other two.
If you are trying to append the two tables to each other, you'd need PowerQuery/Get and Transform, to perform the Append operation.

 

[happyhungarian]

It looks like that method requires the columns to be uniform from worksheet to worksheet. Is that true? The issue I have is that the two worksheets I want to combine come from different sources so the columns aren't uniform. I would need some type of mapping/linking that would say which column on one sheet is equivalent to which column on the other sheet. I'm trying to avoid having to manually consolidate the workbooks/reports into one list so that they can be pivoted together.

Jesse

 

[SpillerBD]

In either case, no.
With either the fields are the named columns and you work with those fields.
With the Get and Transform append, you will want the field names in each Query results to be the same. The Query results should have the same data types assigned.