Revisions to Repeat range under each other in Google Spreadsheets

edited body

Source Link

edited Feb 14, 2018 at 15:14

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

p.s its work, dont look at negative rate

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

p.s its work, dont look at negative rate

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

Post Undeleted by alunet

occurred Sep 15, 2017 at 9:52

Post Deleted by alunet

occurred Sep 15, 2017 at 9:52

added 42 characters in body

Source Link

edited Sep 13, 2017 at 14:37

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

p.s its work, dont look at negative rate

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

p.s its work, dont look at negative rate

added 112 characters in body

Source Link

edited Sep 13, 2017 at 14:29

Ist possible to do it withoutYou can rept range using GAS?formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

Ist possible to do it without using GAS?

You can rept range using formula (for e.g. you need rept range "C1:C4" 2 times):

=transpose(split(REPT(C1&","&C2&","&C3&","&C4&",";2);",";true))

Source Link

created Sep 13, 2017 at 14:08

Loading

Return to Answer