The table has multiple rows where the payment is associated with the payee. The payment and payee can be different for each row and some rows may only have payment 1 and payee 1 or any combination of payment/payee.
I need a table where payment and associated payee are stacked in a single [payment] column and a single [payee] column like this:
New Table = [Payment], [Payee]
I need this so I can set up a report to show all payments and their associated payees.