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