Double Filter?

[Jedi Master]

I have a Master Worksheet (2-Quote Master) that looks at 2 sub master worksheets: (Quote Task Master)(Change Order Master). The Master worksheet is below:

Quote Task Master worksheet is below:

Change Order Master is below:

I am looking to alter the following formula:

=IF('Quote Task Worksheet '!A50="","",LET(X,VSTACK('Quote Task Master'!B30:B39,'Change Order Master'!B30:B39),UNIQUE(FILTER(X,INDEX(X,,1)<>""))))

to give column B where CDL Driver that has no value in column A in either of the sub master sheets is filtered out. I should end up with what the 2-Quote Master looks like above. Can anyone please help restructure the above formula to accomplish this?

 

[RoryA]

Maybe:

=IF('Quote Task Worksheet '!A50="","",LET(X,VSTACK('Quote Task Master'!A30:B39,'Change Order Master'!A30:B39),UNIQUE(CHOOSECOLS(FILTER(X,INDEX(X,,1)<>""),2))))

 

[Jedi Master]

Maybe:

=IF('Quote Task Worksheet '!A50="","",LET(X,VSTACK('Quote Task Master'!A30:B39,'Change Order Master'!A30:B39),UNIQUE(CHOOSECOLS(FILTER(X,INDEX(X,,1)<>""),2))))

Thank you so much!!