Skip to main content
Solved

How to split a row into multiple rows based on cell value

  • March 4, 2021
  • 1 reply
  • 20 views
D
Forum|alt.badge.img

Hi all,

I’m facing the following challenge:

I have a table with a list of Product items (Catalog), to simplify the question I have 3 columns:

Product name | Product ID | Sizes
e.g.
Red Tshirt | 14828 | S,M,L
or
Blue boots | 5423 | 8,9,10,11,12

I need to take a single row and duplicate it & split it per each size as the following:
This original row:
Red Tshirt | 14828 | S,M,L

Should become this:
Red Tshirt | 14828 | S
Red Tshirt | 14828 | M
Red Tshirt | 14828 | L

(So all the other columns have the same values)

Has any 1 ever encountered something like this?

Thanks :slightly_smiling_face:
YV

Best answer by Raminder_Singh

Hello @Dropit_Shopping,

It is doable using a script. Where do you want to put the new rows? In the same table as the source row? Or in a new table somewhere? A little more context about your problem would help.

-Raminder

L

1 reply

R
Forum|alt.badge.img+3
  • Raminder_Singh
  • Participating Frequently
  • Answer
  • March 4, 2021

Hello @Dropit_Shopping,

It is doable using a script. Where do you want to put the new rows? In the same table as the source row? Or in a new table somewhere? A little more context about your problem would help.

-Raminder

Terms & ConditionsAccessibility statement