Paul,

What are you trying to achieve?

Level1 level2 level3 Desc would be fieldnames?

I assume 010 002 BBBBBB a.s.o. to be data?

Where do the data orignate? File, memory?


>Hello,
>
>How to create a new cursor like the table2 below from table1 ?
>
>Any help or suggested coding would be appreciated
>
>TIA
>
>TABLE1
>
>Level1 level2 level3 Desc
>010 AAA
>010 002 BBBBBB
>010 002 005 CCCCCCCCC
>010 002 013 DDDDDDDDD
>010 002 015 EEEEEEEEE
>010 002 016 FFFFFFFFF
>010 002 018 GGGGGGGGG
>010 003 HHHHHH
>010 003 005 JJJJJJJJJ
>010 003 017 KKKKKKKKK
>010 003 028 LLLLLLLLL
>010 003 072 MMMMMMMMM
>010 003 084 NNNNNNNNN
>010 003 085 OOOOOOOOO
>010 003 086 PPPPPPPPP
>010 003 087 RRRRRRRRR
>010 003 088 SSSSSSSSS
>010 003 089 TTTTTTTTT
>---------------------------------
>TABLE2
>
>Desc1 Desc2 Desc3
>AAA BBBBBB CCCCCCCCC
>AAA BBBBBB DDDDDDDDD
>AAA BBBBBB EEEEEEEEE
>AAA BBBBBB FFFFFFFFF
>AAA BBBBBB GGGGGGGGG
>
>AAA HHHHHH JJJJJJJJJ
>AAA HHHHHH KKKKKKKKK
>AAA HHHHHH LLLLLLLLL
>AAA HHHHHH MMMMMMMMM
>AAA HHHHHH NNNNNNNNN
>AAA HHHHHH OOOOOOOOO
>AAA HHHHHH PPPPPPPPP
>AAA HHHHHH RRRRRRRRR
>AAA HHHHHH SSSSSSSSS
>AAA HHHHHH TTTTTTTTT