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
alunet
- 11
- 2