How to read Excel files which contain merged cells

Hi @Akash_Javalekar1 ,

Thanks for your help. I found some arrangements mistakes in Sheet1.

Under PythonProgramming column there should be only 2 sub columns “Course Start Date” and Course Completed Date".

Similarly, under Maths column, there should be only 2 sub columns “Course Start Date” and “Course Completed Date”

Lastly, Completion % column is a separate column. It should not be under Maths.

Could you help me correct those mistakes?

Thank you.