combining 18 columns into 5 columns

[outumbr]

hi
I am devising a school marksheet in excel
I have 21 subjects including maths French and english which are mandatory subjects. all tudents do maths English and French . hence 18 columns with different subjects left .only 5columns out of the 18 are filled as there are many options and a student does only 8 subjects
what I want to do is to fill in the marks in only 5 columns and write the subject beside the marks in another colum.
please help

 

[Rick Rothstein]

I find your question to be a little bit sketchy. Is Column A the student's name? Do you have 18 or 21 (with three pre-marked) columns following that? What type of mark are supposed to go into the columns (perhaps the letter X)? I don't understand what your output should look like nor where it should be located at... can you describe that in a little more detail?

 

[outumbr]

Thanks Rick
col A contains the name of the student
col B contains marks for English
col C marks for French
Col D marks for Maths
Col B C and D are mandatory that is if I have 15 students all of the 15 students have to do English French and Maths
from col E to col V I have 18 subjects
these subjects are optional that is a student can choose any 5 subjects from the remaining 18 subjects

NAME	ENGLISH	FRENCH	MATHS	ADD MATHS	ACCOUNTS	ECONOMICS	COMPUTER	PHYSICS	BIOLOGY	CHEMISTRY	DC	DT	ENTERPRISE	TRAVEL N TOURISN	AL	ART	FRENCH LIT	ENGLISH LIT	SOCIOLOGY	PHYSICAL EDUCATION	BUSINESS ST
BHOOBUN Ivans Madun	45	55	40	60			10	50				72			78
BHUDDOO Anikesh Anand	56	25	46	84			15	40			0					25
BUNDHOO Thanveersingh	49	62	34		72	40	20								62	50					31
BURKATALLY Fardeen	51	52	62	81		25		52				70				50
CHAMPA Heeman	56	61	54				30							34	46	40	57				50

<colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="21"> <tbody> </tbody>

what I am planning to do is to have a for mat as follows
col A name of student
col B marks for English
col C marks for French
col D marks for Maths
col E subject 1 name
col F subject 1 marks
col G subject 2 name
col H subject 2 marks
and so on up subject 5 name and subject 5 marks

ENGLISH	FRENCH	MATHS	subject 1 name	subject 1 marks	subject 2 name	subject 2 marks	subject3 name	subject 3 marks	subject 4 name	subject 4 marks	subject 5 name	subject 5 marks
45	55	40	add maths	60	computer	10	physics	50
56	25	46	add maths	84	computer	15	physics	40
49	62	34	accounts	72	economics	40	computer	15
51	52	62	add maths	81	economics	25
56	61	54	computer	30	traveln tou	34

<colgroup><col width="64" style="width: 48pt;" span="3"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="64" style="width: 48pt;" span="9"> <tbody> </tbody>