Convert columns to rows

[jiaqya]

I have a table like below

A B C

1 2,3,4 Hello

Need a query for which output will be like below
A B C

1 2 Hello
1 3 Hello
1 4 Hello

Split 1 row into different rows based on values in column B

any help ?

[jiaqya · Accepted solution]

This did it

|eval B=trim(split(B,","))
|mvexpand B