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?