Identify last filled column, use location to merge cells 2 rows up

[akg742]

I have a pivot table whose number of columns changes, depending on the data that week. There's a title in the row above the table which doesn't change. I'd like the title cell to be merged from column A to the last column of the pivot table. My title is in row 7 and the pivot table headers (the row which has data in each cell across) is in row 9. For some reason, working with the last cell over is way different than the last cell down for me. And I can't find anything online that goes beyond identifying the last column which is only step one here.

Thanks!