Linked Questions

3 votes
1 answer
3k views

Splitting up comma separated values in a single cell to new rows [duplicate]

Every night, we run a batch that sends data from a point of sale service that sends data to Google Sheets, with the hope that we can trigger a Mailchimp automation or add subscribers (the POS software ...
user avatar
0 votes
1 answer
2k views

Splitting the contents of a comma separated cell into new rows [duplicate]

Based on: https://stackoverflow.com/questions/52376162/combining-column-data-in-google-data-studio I have a long list of data, about 200 rows, and each row contains multiple columns of data and a ...
user avatar
0 votes
0 answers
547 views

Split contents of comma separated cell and send to new row(s) with adjacent cell values [duplicate]

*Question is unique from Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) in that the parse is required in three separate columns rather than just one. I have a ...
user avatar
2 votes
0 answers
192 views

Splitting multiple multi-line cells into new rows [duplicate]

I am working on employee data and the data I have received comes with two cells (Proj Name and Count of Hours) which have multiple names/ hours in the same cell separated by line breaks. I have ...
user avatar
  • 29
0 votes
1 answer
83 views

Google Sheets split by " ," & add new rows [duplicate]

This is an example: I need to split by " , " in a new row and duplicate the others The desired output on a new sheet:
user avatar
  • 1
8 votes
5 answers
9k views

Split a column of strings with a single formula returning an array

I have a column of strings like this: +---------+ | a bb | | ccc d | | ee ffff | +---------+ (exactly one space in each string), which I'd like to split by the space into two columns: +-----+-...
user avatar
0 votes
1 answer
3k views

Split multi-line (comma-separated) cell into new rows + duplicate surrounding row entries

Based on: Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) How can I rewrite this for use of a comma as separator and remove blank spaces? Input sheet: ...
user avatar
-1 votes
1 answer
1k views

Split comma separated cell data into rows while keeping surrounding row data

I'm trying to accomplish the below input and output in Google Sheets. I was actually able to find a partial solution on Stack Exchange. This is the script I pulled, but it only functions on one ...
user avatar
  • 3
1 vote
0 answers
300 views

Split rows by comma into multiple rows and divide between splits

I have a Google Sheets spreadsheet (sheet 1) which I use as source for a function to split a row into several rows in a results worksheet (sheet 2). The split function divides the row when it finds ...
user avatar
2 votes
1 answer
112 views

Split comma-separated cell in sheets while repeating other cell for all entries

I have a Sheet that looks like this: ╔═══════╦═════════════════════════════════════╦══╗ ║ ID ║ Users ║ ║ ╠═══════╬═════════════════════════════════════╬══╣ ║ 12345 ║ ...
user avatar
  • 468
0 votes
1 answer
49 views

How can I make this custom formula work with multiple columns?

I came across this script that is a custom formula: function result(range) { var splitCol = 1; // split on column B var output2 = []; for(var i=0, iLen=range.length; i<iLen; i++) { var s =...
user avatar