Paul,

Interesting problem...

Does the original data (table1) *have* to be stored in this format? Why not have a parent table, with a child table related to it, and a grandchild table, related to the child table?

>How to create a new cursor like the table2 below from table1 ?
>
>Any help or suggested coding would be appreciated
>