how to find text values for a given grade?

[sumesh56]

I want to link two worksheets. worksheet1 is LInk-1-compilation.xlsx and ws2 is Link-2-mark register.xlsx.
i want to link the contents from link-1 , cell c3:i3 to link-2 cells E3:E9. the thing is the data has to be taken in the manner that it is transposed.link-1 is the master file.how can i do this? thanks.
the sample files are attached herewith. thanks.

[bentleybob]

Assuming it's only the marks, not the grades, you're looking for, does the attached work for you?