Forum Discussion

montibellin's avatar
montibellin
Helper I
6 years ago
Solved

duplicate rows when column has double value separate by comma

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.

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

1 Reply

  • edhans's avatar
    edhans
    Community Champion

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