Hi there,

I hope you can help me.

_*DATA_I_HAVE:*_
*Table * of *3 columns*:
-column 1-: up to 60.000 terms
-column 2:- up to 60.000 terms (mostly the same as in column 1; just
different order
(column 1 and 2 are representing a connotation)
-column 3-: weighting of connotation

_*AIM:*_
In order to conduct a better evaluation of the data (connotations) I
need to *transform * the *Table-Sheet * into a *Matrix*,
- having 2 coordinates: 1 coordinate representing column 1, one
representing column 2
and
- filled data (crossing of the terms) representing the weighting of the
connotation(s)

_*QUESTION:*_
Is there a possibility to handle this with Excel or another tool? If
yes, how?

Thanks in advance for your help!
Peter


--
ewaldep
------------------------------------------------------------------------
ewaldep's Profile: http://www.excelforum.com/member.php...o&userid=28567
View this thread: http://www.excelforum.com/showthread...hreadid=482269