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