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 https://webapps.stackexchange.com/q/135318/88163

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 '19 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. – Rubén Oct 8 '19 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 '19 at 16:49
  • @pjmg I'm offering a bounty (see my answer or just go to the Bountied tab on the main page) – Rubén Oct 12 '19 at 0:41

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 .