Linked Questions
11 questions linked to/from Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
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 ...
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 ...
- 1
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 ...
- 9
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 ...
- 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:
- 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:
+-----+-...
user79865
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:
...
- 125
-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 ...
- 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 ...
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 ║ ...
- 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 =...
