View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bill bill is offline
external usenet poster
 
Posts: 21
Default 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