Large dataset sorting help

[kjibbs]

I would like to return a list of values that are attached to a similar string. For example, if my dataset looked like the following:

A B
100 Michael
101 Michael
102 Michael
103 Michael
104 Michael
105 Michael
110 James
111 James
112 James
113 James
230 Nicholas
231 Nicholas
232 Nicholas
233 Nicholas
234 Nicholas
235 Nicholas


I would like code that returns:

A B
Michael 100, 101, 102, 103, 104, 105
James 110, 111, 112, 113
Nicholas 230, 231, 232, 233, 234, 235



As of now I can't figure out any formulas that would automate this process. Any help appreciated!

[Jamie.Reis]

Try this:

Please Login or Register  to view this content.

[nilem]

or this

Please Login or Register  to view this content.