Hi,
I have here a data set that is broken down in 4 columns, the first
one is a code, the second is the ID, 3rd someones name, 4th a
description.
the problem: the description filed is broken down in some cases
over several rows, taking the place of the name field, in this case
the code field changes to indicate that its a continuation from the
row above, ID filed is identical, looks kinda like this.
________________________________
| A | 0003 | Joe Doe | Description |
| A | 0004 | Jane Doe| Description |
| L | 0004 | Description of Jane doe |
| A | 0005 | some else | Description |
---------------------------------------------------------
in some cases the "Description" Field can spread over 4 rows, 1
"A" and 3 "L"'s. Since it shifts one field I have absolutely no clue on
how to get all the apropiate descriptions into a single field.
I'm awake now for around 72 hours... so please excuse if my
grammar, spelling.. reasoning ain't to clear.
Thanx for any pointers...
Ralf
