Column Header Macro

[PhillpJ]

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.

[Bren_Spill2]

@PhillpJ - see suggested solution attached. Thanks

[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 · Accepted solution]

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.

[Bren_Spill2]

Will the final column headers always be Name, Age, Date of Birth, Gender? Will column C always contain dates?