I have about 1,000 rows of data organized into 3 columns (which I'll call a column set):

PHASE CYCLE GREEN
1 3 4
1 2 9
2 3 7
3 5 6
1 4 3
5 9 2
3 7 3
2 4 3

I need to take this single column set and parse it into multiple column sets, based on the value in the first column (PHASE). That is, all the rows where Phase = 1 go together in one column set, all Phase = 2 go in a second column set, etc.

I am extremely bad at VBA, and I'm not really sure how to even get started with this...can anyone help me?

Also, this question is posted here as well: http://www.ozgrid.com/forum/showthre...376#post732376