[EmData] Indata - data manipulations

Didier Mombrun didier.mombrun at knowlink.net
Wed Jun 17 00:51:50 EDT 2009


Hi

I would like to know if it is possible to make this with Xdata / Indata
Without working in excel before ?

It is to make alphabetical Index !

I have an excel file with a list of book title "autors" in a colums  
and page Number in an other one
There are duplicate lines with the same couple autor / page,
There are lines with same autors with other page
and multiple autors separated with "/" in the first colum

The résult : i would like to have only one autor and all the pages for  
each

Exemple
Autors | Page
Autor1 | 1
Autor1 | 1
Autor1 | 2
Autor1 | 3
Autor1 | 3
Autor1 / Autor2 | 5
Autor2 / Autor3 | 6
Autor2 | 7

The résult i would like with xdata / Indata

Autor1 1, 2, 3, 5
Autor2 5, 6, 7

Thanks to help me


More information about the Data-users mailing list