I am currently working on a Google Sheet and I want to split a few columns that have strings into rows across the entire worksheet.

I used a script found on this platform which was helpful but the data came out with some errors. Wonder if someone could help me solve this.

I am very new to javascript.

Original Data looks like this.

To:

References:

• map()
• reduce()