I have 4 spreadsheet files. One is a list of products and prices. The other 3 are warehouse inventory lists. The inventory lists all have the same schema except one column which is the name of the warehouse with a boolean to indicate it is in stock. I am basically trying to combine these spreadsheets into one. Just combining two of the warehouse lists is proving difficult as I don't seem to be getting the right numbers. If I many copy and paste the spreadsheet into a new spreadsheet and use Excel to remove duplicates based on productid, I get a different amount of rows than when trying to use tMap and following the tutorials. I'm not sure what I am doing wrong or what the best way to do this is.
