Hi
I have large set of data in different tables, Is there a way I can get all the data from 3 tables and consolidate it into one single table?
In the attached file you I have tried to create a powerpivot in which the only "Unique" filed available is Supplier ID.
Supplier ID is repeated in all tables but when I connect all tables, i can get the data only from "supplier spend" table.
How and what tool can I use to consolidate the data into one masterfile?
Thanks
Bookmarks