• I don't have the means to test at the moment - perhaps this would work?

    SELECT *

    FROM [Sheet1$B2:Q2]

    UNION

    SELECT *

    FROM [Sheet1$B9:Q]