Google Sheet Custom Function to Unpack Comma Separated Values in one column to multiple lines
- Create or open an existing spreadsheet in Google Sheets.
- Select the menu item Tools > Script editor. If you are presented with a welcome screen, click Blank Project on the left to start a new project.
- Delete any code in the script editor. Copy and paste the code from UNPACK_TABLE.gs into the script editor.
- Select the menu item File > Save. Give the script project a name and click OK.
- All done! Now you can use the custom function.
=UNPACK_TABLE(Table Range Without Header, Column Index with Comma Separated Values, Column Index with Values to Average)
For instance, If data range is A2:E10 Column with comma separated value is column C Column with values to average is column E
The formula should be like this =UNPACK_TABLE(A2:E10,3,5)
- Write Read Me
- Table Header True/False Option
- To work on option to use function without averaging column
- To work on Multiple Comma separated columns