Hello,
I have a problem I have been stuck on for a while.
I have a matrix of information in Excel, but I need to convert it to a list, with one of the columns having every combination of the column and row headings and the other column as the number from the matrix that corresponds to the column and row heading.
Not sure if this is clear - please tell me if it is not.
If anyone has any ideas would be much appreciated.
Henry
I have a problem I have been stuck on for a while.
I have a matrix of information in Excel, but I need to convert it to a list, with one of the columns having every combination of the column and row headings and the other column as the number from the matrix that corresponds to the column and row heading.
Not sure if this is clear - please tell me if it is not.
If anyone has any ideas would be much appreciated.
Henry