Hi
Can anyone offer advice on how to change a list of names with subject grades in multiple columns to a list of just 3 columns. Ending with duplicate names in one column with subjects and grades along side, see example below.
Many thanks Julie
subject1 subject2 subject3 subject4 subject5
Name1
Name2
Name3
Name1 subject1
Name1 subject2
Name1 subject3
Name1 subject4
Name2 subject1
Name2 subject2
Name2 subject3
Name2 subject4
Name3 subject1
Name3 subject2
Name3 subject3
Name3 subject4
Bookmarks