How do I change a table with 2 columns where I have repeating values in both columns into a matrix?
Hopefully I will be able to explain my problem correctly.
I have a table with two columns in it. Column A has students in it, column B has the subject that each student is taking. Both column A and column B have repeating values, but together they are unique. For example
NameSubjectJimmyMathsJimmyBiologyJimmyChemistryMaximeMathsMaximeComputer ScienceMaximeHistory
What I need to do is turn this into a matrix (is that the correct term?) which looks like this
NameSubject ASubject BSubject CJimmyMathsBiologyChemistryMaximeMathsComputer ScienceHistory
Can this be done?
Hopefully I will be able to explain my problem correctly. I have a table with two columns in it. Column A has students in it, column B has the subject that each student is taking. Both column A and column B have repeating values, but together they are unique. For example NameSubjectJimmyMathsJimmyBiologyJimmyChemistryMaximeMathsMaximeComputer ScienceMaximeHistory What I need to do is turn this into a matrix (is that the correct term?) which looks like this NameSubject ASubject BSubject CJimmyMathsBiologyChemistryMaximeMathsComputer ScienceHistory Can this be done? Read More
