Parsing an Excel file with merged cells, missing expected values

[ddiesel]

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:

[Qiu · Accepted solution]

@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.

[ddiesel]

Thank you @Qiu! This solution worked.