I have the left side of this screenshot, but need the right side. What are the formulas for columns D and E?

CodePudding user response：

Use split() and the concatenation operator, like this:

=arrayformula( 
  query( 
    split( 
      flatten( A2:A & "→" & split(B2:B, ", ", true, true) ), 
      "→" 
    ), 
    "where Col2 is not null", 0 
  ) 
)