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?