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.
I will be very grateful for the help!
Add a comment
|
1 Answer
=TRANSPOSE(SPLIT(JOIN(","; ARRAYFORMULA(REPT(SPLIT(
INDIRECT("B2:B"&COUNTA(B2:B)+1); ",")&",";
INDIRECT("C2:C"&COUNTA(C2:C)+1)))); ","))
-
Thanks, @user0! I gess, that did everything right, but unfortunately I've got #ERROR! link Commented May 21, 2019 at 9:16
-
-
-
I've already shared my sheet. Here [link] (drive.google.com/…) @user0 Commented May 21, 2019 at 9:47
-
1