Create dynamic list based on blank cells

Hi Folks,

I run a training oversight workbook and I'm trying to dynamically create a list of users who need to be enrolled in training.

Using data from the "Data Source" worksheet, I'm trying to dynamically create a list on different worksheet based on whether or not the cells in column O or Q is blank.

If one or other (or both) of the cells in columns O and Q are blank, then I want to be able to pull certain values across to the 'desired output' tab (without any blank rows).

• Columns A - M of the "Data Source" tab (Headers marked in Red) MUST be maintained in the order they're in
• I have no issues with having a 'helper' column in column Z of the "Data Source" Tab.

I've tried working it with Index and Aggregate and while I feel I've been close it just doesn't quite work for me.

Any help, as always, will be very much appreciated.

Any questions, queries or clarity needed, drop me a line

MM