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):

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Initial[/TD]
[TD]Name[/TD]
[TD]Program[/TD]
[TD]Admission[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]First year student[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]AB[/TD]
[TD]An Boyd[/TD]
[TD]Business[/TD]
[TD]01-01-2000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]GH[/TD]
[TD]Greg Hall[/TD]
[TD]IT[/TD]
[TD]02-02-2000[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Second year student[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]FG[/TD]
[TD]Fran Grey[/TD]
[TD]Business[/TD]
[TD]01-01-2001[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]HJ[/TD]
[TD]Hamish Joe[/TD]
[TD]Law[/TD]
[TD]01-01-2000[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want to do some kind of lookup that can pair initial with what year they are on.
Ex:
[TABLE="width: 300"]
<tbody>[TR]
[TD]AB[/TD]
[TD]First year student[/TD]
[/TR]
[TR]
[TD]GH[/TD]
[TD]First year student[/TD]
[/TR]
[TR]
[TD]FG[/TD]
[TD]Second year student[/TD]
[/TR]
[TR]
[TD]HJ[/TD]
[TD]Second year student[/TD]
[/TR]
</tbody>[/TABLE]


Can anyone help? -Would be highly appreciated!