Macro for Grouping Rows

[ShanaVT]

Hello! I have about 10,000 rows of data that I need grouped based on certain criteria and I am trying to figure out a way to group them without doing it manually. Below is the sample data and the groupings I am trying to achieve. Any help is much appreciated! Thanks!!!

Total Data

CRN_111111 ABC Program

CRN_222222 DEF Program

CRN_333333 GHI Program

862_0069_0004 Alpha Programs - Group 1

CRN_444444 JKL Program

CRN_555555 MNO Program

862_0069_0001 Alpha Programs - Group 2

CRN_666666 PQR Program

862_0069_0058 Alpha Programs - Group 3

862_0069 Alpha Programs

CRN_111111 ABC Program

CRN_222222 DEF Program

CRN_333333 GHI Program

862_0070_0006 Beta Programs - Group 1

CRN_444444 JKL Program

CRN_555555 MNO Program

862_0070_0020 Beta Programs - Group 2

CRN_666666 PQR Program

862_0070_0058 Beta Programs - Group 3

862_0070 Beta Programs 862 Contracts Level 1 Grouping: 862 Contracts Level 2 Grouping 862_0069 Alpha Programs 862_0070 Beta Programs 862 Contracts <tbody> </tbody> Level 3 Grouping 862_0069_0004 Alpha Programs - Group 1 862_0069_0001 Alpha Programs - Group 2 862_0069_0058 Alpha Programs - Group 3 862_0069 Alpha Programs 862_0070_0006 Beta Programs - Group 1 862_0070_0020 Beta Programs - Group 2 862_0070_0058 Beta Programs - Group 3 862_0070 Beta Programs <tbody> </tbody> 862 Contracts

<tbody>
</tbody>