Find unique values in a row and insert a row after every unique value in a column

Hi All,

I want to know if it is possible with excel formulas to insert a row after every unique value it finds in a column. if not possible with formulas, is here a vb script that is available to do this?

For example if the column is as below, i want to insert a row after every unique value - after 234, after 345, after 567, after 678 and after 789?

123
123
123
234
345
456
456
456
456
567
678
789
890
890
890

THanks,
Arjun Shetty

Hi Sintek,

First of all thank you so much for the response.

However this script is adding a row above the unique value and not below. how can we tweak this to add rows below the unique value and not above.

The below is what is happening:
123
123
123

234

345
456
456
456
456

567

678

789
890
890
890

Sorry maybe there was an error from my side...will cross check again.

Thanks again Sintek

As i said...it was an error at my end..Thank you for this Sintek. Appreciate your help on this

Nigel - Thank you for this as well!!!