I have a report that runs daily from our ERP that contains shipping history for current month. I need to combine the report that was run today with the report that was run yesterday. My issue is this report is always run from the 1st day of the month to the current day of the month every day. This means there is always duplicates on the report. I would be simple if I could just pick one column and tell excel to remove duplicates but this is a shipping report by line item (material) so there is not just one column that has unique duplicates. There is two columns that I can use to call out the duplicates for each row but just don’t know how to do this. The two columns are Delivery and Material. For example the four items at bottom of the report that shipped to Bill’s Farm need to be removed since they are duplicates from the top of the report. I want to do this automatically in the background as this is going to be used in a power bi dashboard. I am now just working on building this out and considering using Power Automate to merge the files together in the background. 

Thanks for your help

DeliveryAct. GdsDateName of the ship-to partyMaterial881462268/16/2024Bill’s Farm23504PTM881462268/16/2024Bill’s Farm23605PTM881462378/16/2024Freddy’s Garage23502PTM881462268/16/2024Bill’s Farm23504PTM881462268/16/2024Bill’s Farm23605PTM

​I have a report that runs daily from our ERP that contains shipping history for current month. I need to combine the report that was run today with the report that was run yesterday. My issue is this report is always run from the 1st day of the month to the current day of the month every day. This means there is always duplicates on the report. I would be simple if I could just pick one column and tell excel to remove duplicates but this is a shipping report by line item (material) so there is not just one column that has unique duplicates. There is two columns that I can use to call out the duplicates for each row but just don’t know how to do this. The two columns are Delivery and Material. For example the four items at bottom of the report that shipped to Bill’s Farm need to be removed since they are duplicates from the top of the report. I want to do this automatically in the background as this is going to be used in a power bi dashboard. I am now just working on building this out and considering using Power Automate to merge the files together in the background.  Thanks for your helpDeliveryAct. GdsDateName of the ship-to partyMaterial881462268/16/2024Bill’s Farm23504PTM881462268/16/2024Bill’s Farm23605PTM881462378/16/2024Freddy’s Garage23502PTM881462268/16/2024Bill’s Farm23504PTM881462268/16/2024Bill’s Farm23605PTM  Read More

​