transpose to matrix
I have a list of items that I want to transpose to a matrix. Scatter Chart won't quite work, particularly because it plots on points and it doesn't list the related item - I want the references to be inside a block or a cell. It seems like there should be a function to group two attributes together, and maybe I just don't know the proper name
From this
EffectA Effect
#1 Low Me
#2 High Hig
#3 Med Me
#4 Low Hig
#5 High Hig
#6 Med Lo
To this
A-Low A-Med A-Hig
B-High #4 -- #2 #
B-Med #1 #3 -
B-Low -- #6 -
Any ideas? Thanks
|