I have a excel table and I want to merge the column header of a single row (peach color), with the same values. The code has to be a loop to check the next column header and merge accordingly. I have attached a excel table, with some random data and would like the Columns A, A, B, B, C, C, C to be merged as shown in the yellow bar above. Only the header needs to be merged, not the data. Please help
Example_Data.PNG
Bookmarks