Google Sheet function in make


I would like to duplicate some information from a Gsheet to another with a certain format. I used to use manually the function =Transpose(Split(CELL#,",")) But I need to deal with a large volume of data so I was wondering how to do it in make so every data is duplicated with the right format into the new spreadsheet.

What have done so far
In Google sheet :

  • Set the column to receive the data

In Make

  • Search rows where the checkbox is FALSE and the cell not empty
    *Add a new row with unformatted data to the sheet

This can be done in 2 to 3 operations max using bulk update:

MSquare Support
Visit us here
Youtube Channel