Take each 3 items from a collection into a Google Sheets row

I have a collection that has a long list of variables that look like this:
child_name1
child_id1
child_birthdate1
child_name2
child_id2
child_birthdate2

child_name12
child_id12
child_birthdate12

I want each “triplet” to go into a new Google Sheets row (one row per child).

I tried using an Iterator, but that put each value into a new row, but I need each 3 values (and not all values are of this pattern, there are others that are not relevant).

How do I do this?

Hi @Crumbs , I used this kind of scenario composed of a repeater and 2 filters before adding a Sheet Row. Can also be used with Iterator, have to replace ‘i’ with ‘Bundle Position’. It does consume some operations though, there should be a better solution to “slice array every x element”, but afaik there’s no native function. Here what I’m doing is basically slicing elements of index i to i+4 if i%4=0 (repeat every 4 elements, in your case 3) and getting all elements from this slice with get(array,1) …2 …3 …4. Keep in mind that array indexes start from 1 in Make.

split in 4.json (57.2 KB)

Thanks for the suggestion @kudracha ! It’s much appreciated. I ended up solving it by using a Repeater module (12 repeats), and then using a switch case on the index of the repetition like this:

2 Likes