I hope I added the attachment correctly. If I didn't... I am wanting to know if there is a simple way to combine the dates of a product to equal one total amount.
For example, I deal with inventory and so most of my reports generate this (it separates each allocated date by the time- show I have to change it to Short Date in Format Cells):
Item--Code-Quantity-Date
Apples--XXX--20--9/10/19
Apples--XXX--20--9/10/19
Apples--XXX--20--10/10/19
Apples--XXX--20--11/10/19
Beans--XXX--57--7/15/18
Carrots--XXX--10--8/27/19
Carrots--XXX--10--8/27/19
Carrots--XXX--10--10/27/19
Carrots--XXX--10--10/27/19
I need my table to combine the dates into one total like this:
Apples--XXX--40--9/10/19
Apples--XXX--20--10/10/19
Apples--XXX--20--11/10/19
Beans--XXX--57--7/15/18
Carrots--XXX--20--8/27/19
Carrots--XXX--20--10/27/19
Can you help me? Or am I stuck going through each item manually?
Bookmarks