I want to analyze data with a pivot table in Excel 2007.
I tried to construct an easy example to explain my question below:
- I have a table (Table2) with data sorted by Person.
- I want to analyze those data with a Pivot Table.
- I want to add additional data about each person to the analysis, which are shown in Table 1.
I could firstly merge those 2 tables to something like Table 3 which could be analyzed with the Pivot Table, however this would lead to a lot of duplicate information (Company name and age are repeated in each row).
So my question is:
Could a Pivot Table in Excel 2007 do that for me and use Table 1 and Table 2 as data and "aggregate" them itself based on the "primary key" Name (given the fact that the name is unique, for sure)?