Thank you for that.
With your steps, what Excel will do is generate the following report.
Vendor/PO/Date/PO #/Memo/Account/Amount
What we are looking for is the PO itself. Let say we have Vendor A, and in PO 1 for Vendor A, we placed 10 of item 123, and 5 of item 234. How can we turn that PO into Excel?
