Help Regarding Splitting Observation with Long String

#1
Can someone please help me with this:

Here is raw data

ID Term
1 1. Horse Riding 2. Fishing 3.Climbing 4. Jumping 5. Hiding
2 1) Horse Riding 2) 100m Running 3) Typing 4)Bungey(200m High)
3 Horse Riding, 100m Running, Hunting, Paragliding + Parachute


Desired Dataset
ID Term
1 Horse Riding
1 Fishing
1 Climbing
1 Jumping
1 Hiding
2 Horse Riding
2 100m Running
2 Typing
2 Bungey(200m High)
3 Horse Riding
3 100m Running
3 Hunting
3 Paragliding + Parachute


It would be really appreciating if you would help me do this. I tried using scan function to replace and output every time. but its doesnot work properly.