Parsing an Excel file with merged cells, missing expected values

Question

I am tasked with parsing some excel files with a messy structure. Some of the values that appear in merged cells are missing when I read in the file to Alteryx. How do I get at the data that I'm missing?

Sample Input:

The red text is missing when I read the file into Alteryx.

Output:

Parse Trouble.yxzp

Excel File to Parse.xls

Qiu · Accepted Answer

@ddiesel 
I am not sure if your workflow allows to change the .xls to xlsx, buf after I saved it as .xlsx, Row#37 is read in somehow.