copy column headers into rows if it meets a specific criteria

hello

this forum have been a great help to me in my past projects and im hoping experts here would extend the same help on my current project.

this macro copies the entire row from "deadlines" X number of times in "que" sheet.

i was wondering if it is possible to copy the headings in column Q-Z and transposed it into rows if the formula result is N/A

i have attached a sample worksheet with a very detailed explanation to express what i want to happen.

this would really be a big help to me...

thanks in advance