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