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.
  • edhans's avatar
    6 years ago

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