Move subtotal grouping title to detail rows

[Teed1955]

Not sure how best to explain.  In my file, I receive has all the invoices for one vendor grouped by a vendor.  The Vendor name is in its own row.  I want to add the vendor names to each row of invoices.  

[#2]

@Teed1955 This looks like a job for Power Query. Are you familiar with it? Must the report look like it is shown in your file (with headers and subtotals etc.)?

[#3]

@Teed1955 

As variant add helper column to the left, on top of it formula

=IF(INDEX($B:$B,ROW())="AP Invoices", INDEX($B:$B,XMATCH("Transaction Type",$B$1:INDEX($B:$B,ROW()),0,-1)-1),"")

Select entire range like A1:A300000 and Ctrl+D

But much better to check if software which generates such reports has the setting to add company name into the line.