Column Header Macro

I am creating a macro that evaluates whether the current header or the one below is appropriate (the rows must not be null or have empty values). The rows above the appropriate header can be disregarded. Below is what I currently have and I am stumped. Please provide any thoughts or help.

Input:

Desired Output:

Thank you in advance.

Heading.yxmc

Workflow

Macros

Accepted answers

SPetrie

Would something like the attached work? It should look for the first row that doesnt have any null or empty values and assume it to be the header row.

Column Header.yxmd

All comments

Bren_Spill2

@PhillpJ - see suggested solution attached. Thanks

Column Header.yxmd

PhillpJ

How can this by done dynamically? I would like the filtering to not reference the actual column heading name since they are dynamic and using this filtering tool would require one to be made for every column, making it static.

Bren_Spill2

Can you provide some more samples of how the data will look?

PhillpJ

The areas above the desired header contain the report details which aren't needed for the table itself

SPetrie

Would something like the attached work? It should look for the first row that doesnt have any null or empty values and assume it to be the header row.

Column Header.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703