Last transaction dates/Inventory

Hi all - I'm using Microsoft Query to extract info from the system and it appears whats happening is if the item has a few bin location the data is being returned in that manner meaning I could have the same item listed a few times

Looking for a means to get the data out in a single row or one record with the last transaction date and total qty for the site in question  

Thanks in advance