I have a number of sheets that contain competition Ladders.
Naturally, before each Ladder I have what Age Group it refers to.
eg: Under 10, Under 11 etc.
These Ladders are quite numerous on the one worksheet.
Is there any way that i can select the title (Select all text 'Under) and once selected, merge each cell across 10 columns which covers all the details of the ladder?
I have attached a simple example of what I would like.
Thank you for you help.
Merge Sample.xlsx