New answers tagged google-sheets-data-validation
2
See Test file Sheet "What I want".
Following formula in I2 returns split list of items and names repeated
=ARRAYFORMULA(
QUERY(
SPLIT(
FLATTEN(
FILTER(Original!B2:B,Original!B2:B<>"")&"|"&
SPLIT(
IFERROR(
REGEXREPLACE(
FILTER(Original!C2:C,Original!C2:C<>""),"...
Top 50 recent answers are included
