-2

For each relevant row I would like to have ColumnC populated with the value from ColumnA repeated (one above the other) in the C cell the number of times there are separate (one above the other) entries in the correponding B column.

WA10513 Q example

Is it possible?

Example sheet

closed as unclear what you're asking by ale, serenesat, Rubén, jonsca Apr 13 '17 at 1:46

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Why is regextract included? What do you mean by "to become more detailed"? Why there are more than one line by cell? – Rubén Apr 12 '17 at 20:21
  • 1
    @pnuts: Congratulations for having your answer accepted. I still think that this question should be improved. – Rubén Aug 19 '17 at 17:37
0

Maybe the result you want can be achieved with:

=ArrayFormula(left(REPT(A1:A&char(10),len(B1:B)-len(substitute(B1:B,CHAR(10),""))+1),LEN(REPT(A1:A&char(10),len(B1:B)-len(substitute(B1:B,CHAR(10),""))+1))-1)) 

but I have made no attempt to optimise it.

  • 1
    Wow.. ! It's so great and wonderful. Hi.. ! pnuts thanks you are so very pretty kind so much It's work very beautiful and thanks once again to you. I have a difficult to explain these all talking it with speaks in english. How best you, you could understand my language as well ... – Deby Ferdian Apr 13 '17 at 7:01
  • if you don't mind with pleasure to solve my any problems on another thread on stackoverflow.com/questions/43345422/… . Probably you could solve that too with so easy looks like an above ealier you did and fix my problem as well too. – Deby Ferdian Apr 13 '17 at 9:50
  • So What sould I do? Do I should post it back to here? – Deby Ferdian Apr 13 '17 at 10:14
  • Wow.. Well I have just know that if there are so many all rules like that what you've just mentioned. But I didn't post it (about any problems) yet in here (SE) ! My mistake is make a thriple duplicates that post in the same site (SO) right ? I have to say so sorry with that and I can't pick it back my questions where was have been there. Meanwhile I correct it that's not about GAS but just formula What I want to do with. – Deby Ferdian Apr 13 '17 at 10:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.