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
[TABLE="width: 263"]
<tbody>[TR]
[TD]CRN_111111 ABC Program
[/TD]
[/TR]
[TR]
[TD]CRN_222222 DEF Program
[/TD]
[/TR]
[TR]
[TD]CRN_333333 GHI Program
[/TD]
[/TR]
[TR]
[TD]862_0069_0004 Alpha Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]CRN_444444 JKL Program
[/TD]
[/TR]
[TR]
[TD]CRN_555555 MNO Program
[/TD]
[/TR]
[TR]
[TD]862_0069_0001 Alpha Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]CRN_666666 PQR Program
[/TD]
[/TR]
[TR]
[TD]862_0069_0058 Alpha Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]862_0069 Alpha Programs
[/TD]
[/TR]
[TR]
[TD]CRN_111111 ABC Program
[/TD]
[/TR]
[TR]
[TD]CRN_222222 DEF Program
[/TD]
[/TR]
[TR]
[TD]CRN_333333 GHI Program
[/TD]
[/TR]
[TR]
[TD]862_0070_0006 Beta Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]CRN_444444 JKL Program
[/TD]
[/TR]
[TR]
[TD]CRN_555555 MNO Program
[/TD]
[/TR]
[TR]
[TD]862_0070_0020 Beta Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]CRN_666666 PQR Program
[/TD]
[/TR]
[TR]
[TD]862_0070_0058 Beta Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]
862_0070 Beta Programs
862 Contracts
Level 1 Grouping:
862 Contracts
Level 2 Grouping
[TABLE="width: 263"]
<tbody>[TR]
[TD]862_0069 Alpha Programs
[/TD]
[/TR]
[TR]
[TD]862_0070 Beta Programs
862 Contracts
[/TD]
[/TR]
</tbody>[/TABLE]
Level 3 Grouping
[TABLE="width: 263"]
<tbody>[TR]
[TD]862_0069_0004 Alpha Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]862_0069_0001 Alpha Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]862_0069_0058 Alpha Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]862_0069 Alpha Programs
[/TD]
[/TR]
[TR]
[TD]862_0070_0006 Beta Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]862_0070_0020 Beta Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]862_0070_0058 Beta Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]862_0070 Beta Programs
[/TD]
[/TR]
</tbody>[/TABLE]
862 Contracts
[/TD]
[/TR]
</tbody>[/TABLE]
Total Data
[TABLE="width: 263"]
<tbody>[TR]
[TD]CRN_111111 ABC Program
[/TD]
[/TR]
[TR]
[TD]CRN_222222 DEF Program
[/TD]
[/TR]
[TR]
[TD]CRN_333333 GHI Program
[/TD]
[/TR]
[TR]
[TD]862_0069_0004 Alpha Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]CRN_444444 JKL Program
[/TD]
[/TR]
[TR]
[TD]CRN_555555 MNO Program
[/TD]
[/TR]
[TR]
[TD]862_0069_0001 Alpha Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]CRN_666666 PQR Program
[/TD]
[/TR]
[TR]
[TD]862_0069_0058 Alpha Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]862_0069 Alpha Programs
[/TD]
[/TR]
[TR]
[TD]CRN_111111 ABC Program
[/TD]
[/TR]
[TR]
[TD]CRN_222222 DEF Program
[/TD]
[/TR]
[TR]
[TD]CRN_333333 GHI Program
[/TD]
[/TR]
[TR]
[TD]862_0070_0006 Beta Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]CRN_444444 JKL Program
[/TD]
[/TR]
[TR]
[TD]CRN_555555 MNO Program
[/TD]
[/TR]
[TR]
[TD]862_0070_0020 Beta Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]CRN_666666 PQR Program
[/TD]
[/TR]
[TR]
[TD]862_0070_0058 Beta Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]
862_0070 Beta Programs
862 Contracts
Level 1 Grouping:
862 Contracts
Level 2 Grouping
[TABLE="width: 263"]
<tbody>[TR]
[TD]862_0069 Alpha Programs
[/TD]
[/TR]
[TR]
[TD]862_0070 Beta Programs
862 Contracts
[/TD]
[/TR]
</tbody>[/TABLE]
Level 3 Grouping
[TABLE="width: 263"]
<tbody>[TR]
[TD]862_0069_0004 Alpha Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]862_0069_0001 Alpha Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]862_0069_0058 Alpha Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]862_0069 Alpha Programs
[/TD]
[/TR]
[TR]
[TD]862_0070_0006 Beta Programs - Group 1
[/TD]
[/TR]
[TR]
[TD]862_0070_0020 Beta Programs - Group 2
[/TD]
[/TR]
[TR]
[TD]862_0070_0058 Beta Programs - Group 3
[/TD]
[/TR]
[TR]
[TD]862_0070 Beta Programs
[/TD]
[/TR]
</tbody>[/TABLE]
862 Contracts
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: