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
- Search rows where the checkbox is FALSE and the cell not empty
*Add a new row with unformatted data to the sheet