Forum Discussion
Excel Tables and Relationship
Hello - I am using excel 2016 standard version, which doesn't have a power pivot, how can I create a pivot table from two tables having duplicate values in each table, I cannot create a relationship ...
ritendersingh2 Create a third table containing unique names and create relationships from each of the transaction tables to the name table.
The relationships could then look something like this: