Timeline for Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 20, 2023 at 22:19 | comment | added | Michael Dimmitt | For me this worked but the terminology has changed and the function should be put at location: Extensions -> AppScripts | |
| May 25, 2021 at 15:42 | comment | added | Garconis |
Was hopeful this would work. I have a similar Sheet, but it has about 300 rows currently. Your script just outputs "Loading...". With an error of "Error: Loading data...". The Apps Script is saying TypeError: Cannot read property 'length' of undefined
|
|
| S Oct 9, 2020 at 11:23 | history | suggested | Tamlyn | CC BY-SA 4.0 |
Clarify instructions on how to use the custom function
|
| Oct 9, 2020 at 10:59 | review | Suggested edits | |||
| S Oct 9, 2020 at 11:23 | |||||
| Feb 28, 2020 at 4:00 | comment | added | Ashish Singh | Brilliantly answered, just one bug. FIRST COLUMN in given range should NOT have the DELIMITER. Temporary workaround is to have serial numbes or static value as first column. Not tried but first blank column should also solve the problem. | |
| May 28, 2019 at 9:48 | review | Suggested edits | |||
| May 28, 2019 at 11:34 | |||||
| Apr 30, 2019 at 0:57 | comment | added | Kyle Pennell | on a really large file, this will likely fail...result too large. | |
| Jan 14, 2017 at 12:16 | comment | added | user2060451 | And how to define the range? ( get this message "cannot read property "length" from undefined" Thanks! | |
| Jun 11, 2014 at 22:49 | comment | added | kirk tab | Awesome awesome awesome - buy this man a beer! Many thanks Jacob, that's exactly what I need. | |
| Jun 11, 2014 at 22:48 | vote | accept | kirk tab | ||
| Jun 11, 2014 at 10:29 | history | answered | Jacob Jan | CC BY-SA 3.0 |