Combine multiple rows into one with a unique identifier

[fordco]

Hello:

I need to combine data that was provided in two rows into a single row. The data has 2 unique identifiers (student_number and date). I've attached a sampling of what the data looks like and the results we need to achieve.

Thanks in advance!

[oeldere]

dutch a18=INDIRECT(TEKEN(64+KOLOM())&(4+(RIJ()-18)*2))

english a18=INDIRECT(char(64+column())&(4+(Row()-18)*2))

And drag to the right.

The formula change in F18 and more to the right.

See the attached file.

Please reply.