Add to cell reference on multiple rows

[craigo298er]

I have a table that I have a lot of production numbers in at regular intervals, say 4/hr at 15min intervals. Each 15min interval is in a different row, all in the same column. How do I quickly populate a table where each hour is on a different row, four columns wide? I know the text =C# doen'ts correspond, it's just to make a point.
I've tried making =C1, =C2, =C3, =C4 on one line, the 5-10 on the next (and that works), but if I click and drag it, it gets all messed up.

Example here since it isn't attaching: https://imgur.com/DTpjmXq

 

[craigo298er]

It does not offend me, if the solution does not work for you, it just does not work for you, I just expected a feedback, saying: "It does not work for me", that's all.
The only thing I was trying to do is try to help you.

I appreciate the help, and I apologize for getting short iwth you

 

[DanteAmor]

Do not worry, have a good day!