consolidated report from two tables containing duplicate values in key column
We have two reports(in form of excel sheets) containing same data structure(but with different values) ,containing columns
Containing -> vehicle no , Time
(where the vehicle no. will be same in both of the reports and will be repeated again and again having different value of 'Time')
How to link these two reports(excel files) to get the reports like sum/avg etc of 'Time' by 'Vehicle No.' from both the tables simultaneously.
I am not able to link these two tables with Vehicle No,as the error message keeps on popping that, Columns with duplicate values cannot be linked.
I also tried linking both the tables with a third table containing containing a table with only "vehicle No"(unique vales in this 3rd table).
bt the powerPivot is not working with this.
Thanks in advance
Bookmarks