Compacting List for Drop Downs

Hi Group

I have 2 small table of products with blank rows or cells between tables.


I want to take this list and compact it for drop down cell options in another section of document.

How to compact tables - See example?

Perhaps

Formula:

Please Login or Register  to view this content.

Pepe Le Mokko

Interesting function.... Works great!

Thanks

Pepe Le Mokko and others

Re-assessed your example with my example worksheet

I see the function searches for "Product"

In my actual table - It has multiple name variations

I attached updated file example

Try this:

=FILTER(C36:D51,(B36:B51<>"")*(D36:D51<>""))

AliGW

I like it!!!


Thanks

You're welcome.