Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I have a spreadsheet with student results that contains data such as Student A (in the first column), then the individual results Chemistry 60, Biology 55, Maths 70, English 80 all in one cell (in the next column), the next row down will contain Student B, Maths 60, Languages 50, Physics 90, next one down might contain Biology 75, English 45, Applied Maths 55, General Science 80 etc. The results for each student are in one cell only making it difficult to do any sort of analysis.
I would like to arrange the data so that instead of meaningless column headings up the top like Column A we have along the top Chemistry Maths English etc, then the scores in the relevant columns for each student.
I can use text to columns to split the data across the columns but the names of the subjects won't be indicated on the spreadsheet. There would be approx. 30 or so units that students could take. Typically no one does more than 4 units at a time. There would be approx 1000 students. There may well be a way to do this without VBA and am happy to do it in anyway that gets the job done.
I would like to arrange the data so that instead of meaningless column headings up the top like Column A we have along the top Chemistry Maths English etc, then the scores in the relevant columns for each student.
I can use text to columns to split the data across the columns but the names of the subjects won't be indicated on the spreadsheet. There would be approx. 30 or so units that students could take. Typically no one does more than 4 units at a time. There would be approx 1000 students. There may well be a way to do this without VBA and am happy to do it in anyway that gets the job done.