Pair header and value in table, in a row

[miwe09ad]

Hi friends

I have really spend some time to come around my problem, with no succes so far.

I got this data set (example) that I'd prefer not to fiddle with (all cells in row 2 is merged to 1 cell, as is row 5):

	A	B	C	D
1	Initial	Name	Program	Admission
2	First year student
3	AB	An Boyd	Business	01-01-2000
4	GH	Greg Hall	IT	02-02-2000
5	Second year student
6	FG	Fran Grey	Business	01-01-2001
7	HJ	Hamish Joe	Law	01-01-2000
8

<tbody>
</tbody>

I want to do some kind of lookup that can pair initial with what year they are on.
Ex:

AB	First year student
GH	First year student
FG	Second year student
HJ	Second year student

<tbody>
</tbody>

Can anyone help? -Would be highly appreciated!