Repeat Rows per number of elements in next column

user_19017318 0
Viewed 26

I have this table:

table 1

However, I need to convert it into something like this:

table 2

Meaning that I need to repeat the first Cell times the number of elements in the next cell (assuming we will split them by ";"). I've tried several approaches, but so far nothing came close to the final table I am showing in the picture. Any help will be greatly appreciated.

google-query-language flatten google-sheets loops split
1 Answers

use:

=INDEX(QUERY(SPLIT(FLATTEN(A2:A&"×"&SPLIT(B2:B, ";")), "×"), 
 "where Col2 is not null", ))
user_56326290
Related