UnMerge cells and then delete rows and columnns

[lookforsmt]

hi! everyone

I am looking to automate my task in excel where the file has several merged cells and then look to delete the extra columns and rows
Also, after every couple of rows there are repeated headers which are duplicate records that needs to be deleted and the empty rows to be deleted
so the final report which was in several rows and column per page will be in printable size landscape report with not more than 2 pages

The above report is retrieved from the core system so trying to do a automation

can anyone help me to achieve my goal
thanks

[bebo021999]

Please upload a sample file to see what to do with coding.

[lookforsmt]

Hi! Thanks for the response. Kindly find the attached excel, there are 2 tabs: Original File tab and Expected Result tab

I need my original file to look like the expected result after applying the vba code

thanks