New answers tagged

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