Perhaps the DataPilot may be of use to you - it is similar to the Excel Pivot Table feature...
http://www.openofficetips.com/blog/archives/2004/09/datapilot_101.html http://www.openofficetips.com/blog/archives/2005/08/datapilot_revis.html http://www.openofficetips.com/blog/archives/2005/08/datapilot_revis_1.html On 11/14/05, David Pettersson <[EMAIL PROTECTED]> wrote: > > 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] > > -- My OpenOffice Calc Website http://www.openofficetips.com
