A1 has the list has specialisation ( From a data validation list )
B1 has the semester no. ( 1 to 6)
Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1
like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...