We have "yet another" question about "data transformation" in that is about having a column filled with values separated by a character that should be split & transposed while keeping the relation integrity with the other values on the same original row.

The question is Format data inserted from google form in sheets (this question was deleted)

Despite that this question doesn't include at this time a description of the search efforts made by the OP, I think that this question could be marked as duplicate of another question, but...

IMHO opinion we already have a lot of related questions and I'm not sure which of them, if any, could be used to mark this question as a duplicate of (by question ID order):

Recently I got the gold badge for but before using my privilege I would like to know if anyone have a suggestion or concern

Other related (just split without the keeping the relation integrity with other values on the same original row)

Related Meta Questions

  • 1
    The problem is twofold, in some cases it is necessary to use a script. In others a formula (although sometimes complex) is sufficient. People are looking for a ready-made solution rather than making the effort to look for it on their own. (please write a script for me)
    – pjmg
    Oct 8, 2019 at 14:36
  • Questions that doesn't include any mention of an effort made by the OP should be voted to be closed as unclear / too broad / duplicate. I think that on cases like this that there is already a solution on this site, the question should be closed as duplicate, then if the OP needs further help, they could edit their question or post a new one. Oct 8, 2019 at 14:41
  • 1
    Okay, we can extend this particular case of split/transpose to every first time users asking a question to get a script done. google-apps-script is polluted with this kind of behavior. These kind of answers : I was hoping that someone could propose a piece of code that I could use in my file. @Rubén, I admire your kindness and patience.
    – pjmg
    Oct 8, 2019 at 16:49
  • @pjmg I'm offering a bounty (see my answer or just go to the Bountied tab on the main page) Oct 12, 2019 at 0:41

1 Answer 1


The oldest question looks to be

Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)

IMHO, besides it's the oldest one, it's good as a faq because it already include several well received answers, some include scripts, other include formulas, by the other hand it already is linked to other eight questions.

I'm offering a bounty on this question to request a canonical answer.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .