Rearranging data

[dkester]

Not sure where to begin...

I have input a set of data of this form: Person, classification, value:

Fred, red, 56
Bill, green, 75
Sam, blue, 23
Mike, red, 18
Jim, blue, 3
Alice, green, 77
Dave, blue 51
etc.

Based on that set of data, I want to get the person with their value into new places organized by classification (color) like this:

Red
Fred, 56
Mike, 18

Blue
Sam, 23
Jim, 3
Dave, 51

Green
Bill, 75
Alice, 77

The new data set has to not just be sorted by color, but the reds have to go into one specific set of cells, the greens in another, etc. I don't know how many of each color I'll have.

Thanks for any advice!
Dan

[popipipo]

Have you tried a pivot table?

[newdoverman]

Maybe a Pivot Table solution would work for you.

[sktneer]

You can also use an advanced data filter along with a macro. Please see the attached file.

I hope it helps.

[newdoverman]

Sorry popipipo, didn't see your post.