I have a simple table with two fields. Each record in the table signifies that that the value in field 1 is compatible with the value in field 2. Like this:
F1 > Item 1; F2 > Item 2
F1 > Item 1; F2 > Item 5
F1 > Item 1; F2 > Item 6
F1 > Item 1; F2 > Item 9
F1 > Item 2; F2 > Item 4
F1 > Item 2; F2 > Item 5
I would like to create a matrix with the values of F1 on the X axis and F2 on the Y axis. There are 56 individual items (hundreds of compatibilities) so I would like to create a matrix 57 rows by 57 columns (1 for headings). In the intersections, where there is compatibility I would like to add an "Y" otherwise leave blank.
Ideally (but not essential) I would like to be able to cut and paste or export into Excel so I can turn the column headings through 90 degrees to make more compact.
I know what I want, but i don't know how to do, can anyone help?
F1 > Item 1; F2 > Item 2
F1 > Item 1; F2 > Item 5
F1 > Item 1; F2 > Item 6
F1 > Item 1; F2 > Item 9
F1 > Item 2; F2 > Item 4
F1 > Item 2; F2 > Item 5
I would like to create a matrix with the values of F1 on the X axis and F2 on the Y axis. There are 56 individual items (hundreds of compatibilities) so I would like to create a matrix 57 rows by 57 columns (1 for headings). In the intersections, where there is compatibility I would like to add an "Y" otherwise leave blank.
Ideally (but not essential) I would like to be able to cut and paste or export into Excel so I can turn the column headings through 90 degrees to make more compact.
I know what I want, but i don't know how to do, can anyone help?
