More clarification:

I perhaps could have been a bit clearer in what I'm after -

I need a formula that looks down the list of student numbers (each student
is probably listed several times), and if the type of number that is found
(Mob1, Mob2, Office1etc) matches the current column heading, then put the
value of the telephone number into the cell.

Many thanks

Winger


"Winger" wrote:

I'm trying to tidy up 65,000 lines of student data ready to export into
another system. Our current spreadsheet has a sepearte line for each
telephone number we have for each student (S1, S2 etc).

So it currently looks like this:

S1 Mob1
S1 Mob2
S1 Home1
S2 Office1
S3 Mob1
S4 Home1
S4 Office 1
S5 Mob 1

I want each student to have just a single entry (down the page) and then the
type of number we have for them across the page, like this:

Mob1 Mob2 Mob3 Home 1 Office1
S1
S2
S3
S4
S5


I need a function (or combo of moves) so that the spreadsheet goes and
checks that we have (for example) a Mob1 for S1, or Mob2 for S1 and puts the
right phone number in the right boxes.

Any advcie / guidance on how to tackle this would be much appreciated.

Thanks

Winger