rearranging cells in a column

Hi anyone,

I've got the following problem:
A1=0
A2=0
A3=0
A4=100
A5=100
A6=100
A7=120
A7=120
A8=80
A9=80
A10=80
A11=90
A12=130

I'd like to ignore the repeating data and have the following column:
B1=0
B2=100
B3=120
B4=80
B5=90
B6=130

Is it possible to be done with formulas instead with programming (VBA, Macros, etc.)?

Any help is much appreciated. Thank you in advance,

kras

Hi,

Thank you for the prompt reply.

I must have been more detailed with my problem!

1) The problem is that the data in Column A is dynamic. It is an output from other calculations and as it changes I need the corresponding data in Column B to changes accordingly.

2) Additionally, if there are two or more clusters with the same data only one is regestered (e.g. if A12=100, A13=100, etc., then the value 100 on that cluster would not be regestered, since before it there was another cluster with the same value A4:A6). I need the data from the consecutive same value clusters.

Thank you again,

kras