View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave[_14_] Dave[_14_] is offline
external usenet poster
 
Posts: 1
Default convert matrices to table

Hi to everyone, is it possible to view a matrix in table mode?

I have a matrix like this
b c d e f ...
b 1 0 3 4 5
c 2 5 8 6 5
d 2 3 6 8
e
f
....

I want to convert it in a 3 row table:
ROW COL VALUE
b b 1
b c 0
b d 3
b e 4
....



In one word, that's the opposite of what the pivot table does! :S

thanks!

Dave