duplicate rows when column has double value separate by comma

[montibellin]

Hi guys,

is there a way to transformate the table duplicating (or tripling) the rows when a specific column ha double (or triple value)

the image below can explain better my request.

[edhans · Accepted solution]

Select Column B, right-click on it, Split Colums, By Delimiter, and change the advanced settings to Rows.