Identifying and merging matching ID's within range automatically

1. DON'T QUOTE WHOLE POSTS !
2. check this one:

Index	Activity ID Start	List
1	ENGSCM00001
2	ENGSCM00002
3	ENGDET001
4	ENGDET002
5	ENGDET003
6	ENGDET004	ENGSCM00002FF,ENGDET002FF
7	SCPCSR001
8	SCPCSR003	ENGSCM00002FF
9	SCPCSR002
10	SCPCSR004
11	ENGSCM00002

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)