Hi,
I use calc for data processing in my research. I have a number om
columns which looks simplified like this
num A B C D E F
1 a x l
2 c y f
3 a y k
A want to add another column that contains all the data in compressed
form like this
num A B C D E F Compr
1 a x l A(a)C(x)E(l)
2 c y f A(c)D(y)E(f)
3 a y k B(a)C(y)F(k)
That is I want is the results from
for each column: if cell not empty
-> concat <column_heading>(<cell_content>) to result;
else
-> concat nothing to result;
Here, <column_heading> is the content of the cell in the column in
question on row number 4.
What I actually want to do is to find out all types of combinations that
occure in the data and to find its frequencies. The number of colums is
to large to do this by "sort and count". I would be grateful for other
ways to achive this goal as well.
Thanks
David Pettersson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
