Multiple columns into 1 column

[Hickmanyada]

I have a sheet with multiple columns they are of varying rows:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Header[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Reading Number[/TD]
[TD]Date[/TD]
[TD]Channel 1[/TD]
[TD]Channel 2[/TD]
[TD]Channel 3[/TD]
[TD]Channel 4[/TD]
[TD]Channel 5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]09/08/2015[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]09/08/2015[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3
[/TD]
[TD]09/08/2015[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4[/TD]
[TD]10/08/2015[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]5[/TD]
[TD]10/08/2015[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]6[/TD]
[TD]10/08/2015[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]7[/TD]
[TD]11/08/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to collect all the values from column C - wherever the values stop. I want to put them into column C under the last value.
Columns C-wherever will not have more than one value so if there was a way to move them over into column C no data would be lost. On the example above it would just be moving D7 and D8 to C7 and C8, then E9 to C9. But obviously my data set runs into the hundreds. Columns A and B are always present.

What would the script be for this?

 

[portews]

If all you care about is having some value in column C, I would insert a column before C and put a formula in C3 something like:

=max(&d3:$h3)

and drag it down the whole column. That will give you the maximum value for the D to H columns for each row. No VB required.

 

[Hickmanyada]

Yeah, adding that with another script I've got running works a treat, thank you