I have excel sheet attached in that i have 18 pages each page contains student exam information like registernumber and subject details. But i need the register number to be placed in the next cell to the subject name.
Sample
Sem Subject Subject Title
No. Code
02 070030003 ENGINEERING MATHEMATICS -II 070107126051
06 070290073 ANTENNAS AND WAVE PROPAGATION070107126051