Split Data From Single Column Set Into Multiple Column Sets?

  • 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.excelforum.com/exce…umn-sets.html#post3909953

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!