Automatic row creating based on item inside

Hello everyone, my goal is to create (n) row based on how many item the “attributesName” column have.
example:
The first contact you see in the table have 2 items, so the function should create 2 row with the following setup:
email | attributesName | attributesValue
[email protected] | PRODUCTNAME | nnn
[email protected]| SALE_ID | 12

so the first item of the column will be with the first item of the second column…etc
feel free to ask me

Hey @Gabriele_Bracciali,

So you want to only include the attributes that are named rather than the empty ones as well?

I would like to create a new table, with the following format
email | attributesName | attributesValue
[email protected] | PRODUCTNAME | nnn
[email protected]| SALE_ID | 12

so every time a contact have a multiple item inside “attributesName” “attributesValues” columns the function should create n row based on the number of item

Oh I see so create multiple items instead, Using the previous example as a base the below should do what you are after.

2 Likes

That’s what i need, super fast

1 Like

little point, i noticed that there is a space before the word after the ,

if it’s possible to remove it, it’ could be great

Try this…

1 Like

nice, sound good, thank you man!