How to Group with Matching records and give name to the grp

Question

Hi,

i'm strucked with this place, where i need to group the matched records to a group and give name to the group like shown below.

 

Case 1:  

Id         Number         Occurrence

1            1234               New

2            2345               1234

3            3456               2345

4            4567               New

5            5678               4567 

 

Here...Numbers are mapped with Occurrence place 

 

Case 2

Id            Number           Occurrence

1               1234                    New

2               2345                   1234

3              3456                    1234

4              4567                    1234

 

Here.... also Numbers are mapped with Occurrence place

 

My Output should be like shown below for Case 1:

 

Solution for Case 1:

Id           Number        Occurrence      OccurrenceTimes

1           1234                 New                     P1

2           2345                1234                     P1

3           3456                2345                     P1

4           4567                New                      P2

5           5678                4567                     P2

 

 

Solution for Case 2

Id           Number        Occurrence      OccurrenceTimes

1           1234                   New                     P1

2           2345                   1234                    P1

3           3456                   1234                    P1

4           4567                   1234                    P1

 

Pls anyone suggest for above Solution Cases. Using linq or???

 

Regards,

Lokesh