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