Is this even possible without recording a macro. I have a column with
setting's entered. say b4:b28. In this column diffrent chemical settings are
entered. You may start the day at 130 but during the course of the day this
may change. The changes are entered in the same column but diffrent row. What
I need is at the end of the day I want the settings to be arranged in the top
spots of a diffrent column. I really do not want to record a macro to sort if
I do not have to because I have multiply columns with different settings. I
want to skip the blank cells and have the cells with settings in at the top
of a seperate column. The cells between the settings are blank.

Thanks in adavance
Scott

Example Finish if possible
B4
183 183
134
120

134
120



etc to b28