**Please see sample doc:**

<https://docs.google.com/spreadsheets/d/1Yfry2Xf26JVLeoSXpzuzT8HWZhQz4sQK5KJ5clbH-Dg/edit#gid=0>

I have 2 columns of data. Col1 = id Col2 = 3 data points, but multiple rows of this data just repeats after itself in a single cell.

```
[id][text1 num1 num1 text2 num2 num3 text3 num3 num3]

```

and I need it to look like:

```
[id][text1][num1][num1]
[id][text2][num2][num2]
[id][text3][num3][num3]

```

I found [this script](https://webapps.stackexchange.com/questions/60861/google-sheets-split-multi-line-cell-into-new-rows-duplicate-surrounding-row-e) which is able to give me the IDs in each row, but because it splits by " ", it ends up creating 2 columns and gives every value in the array an `[id]`. I also had a separate formula written that was helping me transpose the data so I could force it into 4 columns. Both script and formula are in the linked spreadsheet.

**Possible Solution // Question**

Is there a way to replace every third " " (before every `[text]` value) with another delimiter? Or even split on every 3rd " "?

Stuck here and would really appreciate some ideas or other methods of attack. Thanks!