Create new array/rows using CSV in single cell in Google Sheets-CodePudding

Home > Mobile > Create new array/rows using CSV in single cell in Google Sheets

Create new array/rows using CSV in single cell in Google Sheets

Time：08-10

Using the cell with CSV as the reference, I would like to create a new array/row set with each variation.

| Original                  | Desired       
| Name  | Parameters        | Name  | Parameters
---------------------------------------------------
| Co1   | Param1            | Co1   | Param1
| Co2   | Param2, Param3    | Co2   | Param2
| Co3   | Param3            | Co2   | Param3
| Co4   | Param2,  Param1   | Co3   | Param3
|       |                   | Co4   | Param2
|       |                   | Co4   | Param1

Some progress has been made.