Report with grouped/sub-totaled by vendor - Need vendor name and number on each txn

Good afternoon,

We got a vendor transaction report from the system that groups and sub-totals the payment data by vendor. However, we want to analyze each vendor payment transaction and would like the vendor name and number that's summarized at the top of each section to be copied as a column for each transaction. Please see sample file attached.

If you can't open the file, below is an example of the problem:

What the file looks like currently:

Vendor # 123 Vendor Name ABC
Invoice # Invoice Amount $ Date Payment Amount $
A123 $10,000 1/1/2016 $10,000
B123 $5,000 1/7/2016 $5,000

Vendor # 567 Vendor Name DEF
Invoice # Invoice Amount $ Date Payment Amount $
C123 $10,000 1/10/2016 $10,000
D123 $5,000 1/15/2016 $5,000
E123 $10,000 1/10/2016 $10,000
F123 $5,000 1/15/2016 $5,000

What I want the data to look like (without having to go one by one as the data file is thousands of records long):

Invoice # Invoice Amount $ Date Payment Amount $ Vendor # Vendor Name
A123 $10,000 1/1/2016 $10,000 123 ABC
B123 $5,000 1/7/2016 $5,000 123 ABC
C123 $10,000 1/10/2016 $10,000 567 DEF
D123 $5,000 1/15/2016 $5,000 567 DEF
E123 $10,000 1/10/2016 $10,000 567 DEF
F123 $5,000 1/15/2016 $5,000 567 DEF

I tried a vlookup formula but it would need to be adjusted for each grouping since each has a different # of rows within it.

Your help is much appreciated.
Thank you

Originally Posted by ChemistB

In your file, is the Payment amount, column C? Is the voucher, the same as Invoice Number?
If not, please clarify.

I apologize the payment amount is not included in the file example. The invoice number is column C. What I'm looking to do is add the corresponding vendor number and vendor name at the end of each row. Hopefully that helps