Hello everyone... I have a problem.

What I need to do is somewhat hard to put into words. I need to do two
things, at the same time, with a group of data. I have about 3,700
rows of data. Column 'B' has numeric codes in it. These are actually
DOE school codes (e.g. 001253, 002561, etc.). Each one of these codes
has about 5 columns associated with it. In these columns will be
either the number 0, 1, 2, or 3. Below is an example:

00125300 3 3 0 0 1
00125300 0 1 2 0 3
00125300 3 3 1 2 0
00125300 1 2 3 1 2
00125300 2 0 0 3 0

In this example, you have one school (00125300) listed 5 times due to
the school having 5 users. Each user has a different level of access
to certain tasks, which are represented by the numers 0-3. What I need
to do are the following:

1) Compare all five "users", and take the highest value and place in a
single row.

2) Identify that the school is listed 5 times, and delete 4 of the
duplicate entries.

So, in a nutshell, in the example above, I would would want to "end up"
with one row with the school code 00125300, and 5 columns of 3's...
Since each column has at least one 3 in it, that would be the highest
value.

00125300 3 3 3 3 3

So I need to recognize the duplicates, compare the values, take the
highest, put into one row, and delete the others. Impossible? It is
to me... Any help at this point would be greatly appreciated!! Thank
you all for taking the time to try to make sense of this!!