Repeat iterations Until New Value Is Seen in Column1

[Ankur]

First , please refrain from posting duplicate questions on the forums. We have deleted the first question this time.

Here is the algo you can try -

1. Start the loop for ColA
   
2. Store the value of column A in a variable say strColA
   
3. Start a loop for ColB
   
4. Compare the strColA for the current values of ColA, say tempColA on every iteration. 
   
5. As soon as strColA is not equal to tempColA, exit the ColB loop.
   
6. Now your loop of ColA will repeat 1-5 till it process each row for ColA.