So I have a bunch of data in an excel spreadsheet that looks something like this:
Level Item No Description
1 XYZ Project
2 General Items
3 Class A: General Items
4 1 Contractual requirements
1.01 Performance security
1.02 Parent company guarantee
1.03 Advance Payment Bond
4 2 Contractors Insurances
2.1 Contractors Construction
4 3 Specified Requirements
3.01 Establishment
3.15 Removal
3.16 Design
3.17 Operation
2 4 Maintance
4.1 Traffic diversions
4.2 Traffic regulation
3 5 Local access roads within work site areas
5.1 Design, supply and install
5.2 Operation and maintenance
5.3 Handover to other Contractors
1 6 Removal
6.1 Design
6.2 Operation
2 7 Advance Payment Bond
7.1 Contractors Insurances
7.2 Contractors Construction
I'd like to automatically create groups in the worksheet based on value in column A the result should be like this as show in the picture
Level Item No Description
1 XYZ Project
2 General Items
3 Class A: General Items
4 1 Contractual requirements
1.01 Performance security
1.02 Parent company guarantee
1.03 Advance Payment Bond
4 2 Contractors Insurances
2.1 Contractors Construction
4 3 Specified Requirements
3.01 Establishment
3.15 Removal
3.16 Design
3.17 Operation
2 4 Maintance
4.1 Traffic diversions
4.2 Traffic regulation
3 5 Local access roads within work site areas
5.1 Design, supply and install
5.2 Operation and maintenance
5.3 Handover to other Contractors
1 6 Removal
6.1 Design
6.2 Operation
2 7 Advance Payment Bond
7.1 Contractors Insurances
7.2 Contractors Construction
I'd like to automatically create groups in the worksheet based on value in column A the result should be like this as show in the picture
