Transpose and Merge headings

Im having a formatting issue on some data. I have a list of repeated names with dated results. I want to merge the single name above the dated results on a new page.

I have attached an example for a more complete explanation. Thank you for your help!!

Hi Mike, thank you for your help on the previous post "transpose and merge headings" it is working beautifully. I would like to add a coulumn to it and unsure how to add make it work. We have added "Cumm BOE" on the right of BOE in the "Results" page after the macro is ran. This function simply adds monthly production month 1 to month 2, month three and keeps a running tabulation of cummulative production so it is easy to line graph. We will then graph this on an additional page called "ProductionGraph". The additional data for Cumm BOE will be sourced from the "MasterData" page. My ultimate goal is to combine 3-4 macros to make a simple click from a raw data download and make it all appear in a prodution report format. Any advise would be helpful.

Mike I am getting a runtime error "13" the debug directs me to this code below , specifically the first line

For i = 2 To UBound(a)
x = Join(Array(a(i, 1), a(i, 2), a(i, 3)), ",")
If Not .Exists(x) Then
.Item(x) = Join(Array(a(i, 6), a(i, 7), a(i, 8), a(i, 9), a(i, 10)), ",")
Else
.Item(x) = .Item(x) & "," & Join(Array(a(i, 6), a(i, 7), a(i, 8), a(i, 9), a(i, 10)), ",")
End If
Next

no nothing has changed but.... It mysteriously started working.

Thank You