I am working on a worksheet that has multiple columns filled with strings. I need to split the strings and have the targetted columns E, F, G repeat as many times as the columns with the longest string to its right.

From: To:

Here's the link to the

Note:

• In this script, your sample Spreadsheet is used. So when your actual Spreadsheet is different from your sample one, the script might not be able to be used. Please be careful about this.

References:

• map()
• reduce()