1

In Google Sheets I try to copy cells B2:B4 depending on values in other cells C2:C4. For example - example.xlsx made in Excel.

But stuck and can't find a solution on how to do it in Google Sheets.

enter image description here

I will be very grateful for the help!

0

=TRANSPOSE(SPLIT(JOIN(","; ARRAYFORMULA(REPT(SPLIT(
 INDIRECT("B2:B"&COUNTA(B2:B)+1); ",")&","; 
 INDIRECT("C2:C"&COUNTA(C2:C)+1)))); ","))

0

|improve this answer|||||
  • Thanks, @user0! I gess, that did everything right, but unfortunately I've got #ERROR! link – Chain EvroSmak May 21 '19 at 9:16
  • can you share a copy of your sheet? – user0 May 21 '19 at 9:17
  • @ChainEvroSmak answer updated – user0 May 21 '19 at 9:22
  • I've already shared my sheet. Here [link] (drive.google.com/…) @user0 – Chain EvroSmak May 21 '19 at 9:47
  • 1
    Thank you very mach, @user0! You are my hero! :) – Chain EvroSmak May 21 '19 at 10:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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