hello experts

we got may time solution with this forum once again we face a problem and i came here for soultion. hope we also get this time

We have a very large road recrod in this record in colum D we have follwing type data

1
2
3(200)
3(200)
3(600)
4
5
6(100)
6(900)
.
.
.


we want convert this data in follwing type

1
2
3-1
3-2
3-3
4
5
6-1
6-2


actually where matter in between () those cell change () text to start no - 1 or 2 or 3

we attach sample file for ur kind perusal




thanks in advance