Extracting data from a table with merged cells

Dear Excel Community    I'm trying to extract data from a table with merged cells into a new table (that doesn't include merged cells).    This is an extract of the table I want to extract data f...