I have a Google Spreadsheet where the first column is multi-valued (not all rows though) and also a few other columns. Not all columns are multi-valued. The values are separated by ',' Here is an example:  10001a, 10001b | 8904083514008, 8904083512400 | DAILY NEEDS | ATTA | 24 MANTRA ORGANIC | WHOLE WHEAT ATTA | 24 MANTRA ORGANIC WHOLE WHEAT ATTA | 1 KG, 10LB | 3.99, 7.99 Would like to transform such a row into multiple rows and removing the original row. So the above one would be transformed as follows (-1 row +2 rows):10001a | 8904083514008 | DAILY NEEDS | ATTA | 24 MANTRA ORGANIC | WHOLE WHEAT ATTA | 24 MANTRA ORGANIC WHOLE WHEAT ATTA | 1 KG | 3.99 10001b | 8904083512400 | DAILY NEEDS | ATTA | 24 MANTRA ORGANIC | WHOLE WHEAT ATTA | 24 MANTRA ORGANIC WHOLE WHEAT ATTA | 10LB | 7.99 How can this be done with Apps Script?
Convert the data from comma-separated cells into repeated rows
google spreadsheets;google apps script