[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