I am trying to create a register (see below) with data extracted from two google sheets cells in a multi row spreadsheet.
I am almost there but have the following issues:
-
When the text aggregator pulls the data from the iterator I need it to ignore blank cells in one array.
-
When sending the text aggregator output to the Google Docs table, I need it to put each name in a different row in the table.
Can anyone help? Thanks for the volunteers that help us learn- without this, the Academy only helps so far.
2Register.blueprint.json (34.1 KB)



