aakira, have a look here and see if this will do what you want.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

Signature
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
> I need to know if there is a way to take a file that is simply 2 columns
> worth of sorted data and have it print where there are 2 or 3 sets of 2
[quoted text clipped - 4 lines]
>
> I hope this describes clearly what I'm trying to do.