I have an extracted table and want to combine the rows if Page, Main Heading and Sub Heading are equal. I want to combine them into one row. You can see in the attached that for this criteria, there are multiple rows and combining them would be easier to read.
How could this be done? It is something that i will repeat often and vba code I suppose could do this.
The headings will always be the same.
Please see attached doc. Thank you