skipping unwanted rows and consolidating required data

[srk0609]

I have a excel file where I'm supposed to skip unnecessary rows of data and join rows that are listed below the column name how can I do that. I uploaded image and file of data can some help me? There are 2 sheets 1)how it is 2)how I want

[binuacs · Accepted solution]

@srk0609 one way of doing this

[Raj]

@srk0609 please find attached 
hope this helps.

[srk0609]

Thank you it worked