Student Grades Distribution Chart

Hi All,
Long time reader first time poster here!
I have an excel 2007 spreadsheet that holds students grades as a percentage.
What I'd like to do initially is display them on a scale from 0-100 with the student name next to each mark. I could do this fairly easily using Vlookup but I can't figure out how to accommodate students with the same mark. On a simple worksheet the names just overwrite each other, I can't understand how I'd get it formatted like this......

60
59 Wayne
58
57 Bob,Jim,Sarah,Tim
56
55 Alex
54

any ideas? Is it a job for a macro or am I missing something simple

Many thanks
Steve

Thanks for the quick response. I've not used macro's before but I managed to get it working eventually, but only if I put the data where you specified in the macro.
I had a couple of issues,
My 0-100 numbers were calculated by formula and had multiple decimal places, even though I'd changed the formatting to display them as whole numbers the macro didn't like it unless they really were whole numbers.
My data is in different columns,
names in 1
scores in 12
0-100 in 15
target names column is 16
all the data begins from row 4.
I tried changing your values but i think I got a bit lost
I'll try again with it, at least now I can get somewhere.
I'm using excel 2007 by the way.

Many thanks
Steve

It still not working unfortunately. I'm sure I'll sort it out soon though!
The 'Int' you put in helped but it seems to just chop off the decimal places, I stumbled across 'round' which does the job better, plus the kids won't complain that their %'s haven't been rounded up!

Many thanks
Steve

I'm not sure what I need to change to get this working now. I've started with a fresh set of basic data based on the info in this thread. I always get "Object variable not set (Error 91)" when I execute the macro. The original macro worked with the data in the places you specified

I managed to sort this out int he end. I moved the 1-100 numbers from to the first column but beneath the main table of data, this has done the trick.
Thanks mrice