I’ve been at this for a while but can’t find a way to do it. All of my attempts basically suffer from the same thing: Calc wants to offset the row index by my cell selection size and I can’t figure out how to suppress that behavior. I want to reference values in column A and repeat them multiple times in column B
I’ve attached an image that (hopefully is clear) that illustrates what I’m trying to accomplish.
Hallo
Start in B2 with =INDEX(A:A;QUOTIENT(ROW()+4;3)) and pull down.
Wow, that works, I don’t understand it at all, but it works 
Thank you!
Let’s say I wanted to repeat the value 4 times, what would I need to change in that formula? I tried the last argument before posting here but it results in grabbing the value from Row 1 “configuration”
Hallo
……+6;4))
… mathematically simple: (row 2)+4 / 3 = 2; (row 3)+4 / 3 = 2.333; (row 4)+4 / 3 = 2.666; then (row 5)+4 / 3 = 3, and so on. Only the integers are preserved if you use the function =QUOTiENT, and they refer to the line number.
Thanks, I understand it now. Your argument delimiter ( ; ) was throwing me off, I thought it was some special syntax. Thanks for the help!
complete formula: =INDEX(A:A,QUOTIENT(ROW()+6,4))