Spreadsheet: 868128d1714869911-power-query-nested-subgroups-index-on-3-sublevels-cost-centre-master-example-with-proper-data-set
Sheet: Cost Items

Column A, B, C Source for Power Query |  |  |  | Power Query - Group and index [NAME] ( 1 to 6) | Power Query - SubGroup and index per Header Group | Power Query - Subgroup again. Item = Null should always be 00, then index other  per Subheader Group | Power Query - Conditional column based on Cost Type SC = 1, LB = 2, MT = 3, PL = 4, OT = 5, SM =6, RV =7) | Combine D,E,F,G,H | Split I
Headers | Subheaders | Items Description | Cost Type | Header Code | Subheader Code | Item Code | Cost Type Code | Cubit Cost Centre | Jobpac Cost centre | Jobpac Cost type
Fees and Insurance | Long Service Leave Corporation | [NAME] | OT |  | 01 | 00
Fees and Insurance | Bank Guarantees | [NAME] | OT |  | 02 | 00
Fees and Insurance | Council & Statutory Fees | [NAME] | OT |  | 03 | 00
Fees and Insurance | Insurances | [NAME] | OT |  | 04 | 00
Preliminaries | Cleaning and Waste | [NAME] General 10m3 | OT |  | 01 | 01
Preliminaries | Cleaning and Waste | [NAME] 10m3 | OT |  | 01 | 02
Preliminaries | Cleaning and Waste | Final clean (Floor Area) | SC |  | 01 | 03
Preliminaries | Cleaning and Waste | Periodic clean | SC |  | 01 | 04
Preliminaries | Cleaning and Waste | [NAME] General 10m3 | OT |  | 01 | 05
Preliminaries | Cleaning and Waste | [NAME] 10m3 | OT |  | 01 | 06
Preliminaries | Cleaning and Waste | Final clean (Floor Area) | OT |  | 01 | 07
Preliminaries | Cleaning and Waste | Periodic clean | OT |  | 01 | 08
Preliminaries | Site establishment and Protection | Protection to Existing Structure | SC |  | 02 | 01
Preliminaries | Site establishment and Protection | Dilapidation Report | SC |  | 02 | 02
Preliminaries | Site establishment and Protection | Survey | SC |  | 02 | 03
Preliminaries | Site establishment and Protection | Setout/ Profile Material | SC |  | 02 | 04
Preliminaries | Site establishment and Protection | A Class Hoardings | SC |  | 02 | 05
Preliminaries | Site establishment and Protection | Site Fence 1800[NAME] high, with mesh | SC |  | 02 | 06
Preliminaries | Site establishment and Protection | Site Fence 1800[NAME] high, clad with waterproof ply | SC |  | 02 | 07
Preliminaries | Site establishment and Protection | Builders Site Sign | SC |  | 02 | 08
Preliminaries | Site Labour | Site Manager - Day | SC |  | 03 | 01
Preliminaries | Site Labour | Site Manager - Night | SC |  | 03 | 02
Preliminaries | Site Labour | Site Supervisor - Day | SC |  | 03 | 03
Preliminaries | Site Labour | Site Supervisor - Night | SC |  | 03 | 04
Preliminaries | Site Labour | Foreman / Leading Hand Carpenters - Day | SC |  | 03 | 05
Preliminaries | Site Labour | Foreman / Leading Hand Carpenters - Night | SC |  | 03 | 06
Preliminaries | Site Labour | Carpenter - Day | SC |  | 03 | 07
Preliminaries | Site Labour | Carpenter - Night | SC |  | 03 | 08
Preliminaries | Site Labour | Apprentice - Day ( Either all as one or Split into 1st, 2nd, 3rd and 4th yr......) | SC |  | 03 | 09
Preliminaries | Site Labour | General [NAME] | SC |  | 03 | 10
Preliminaries | Site Labour | General [NAME] | SC |  | 03 | 11
Preliminaries | Site Labour | Project Allowances (incl LAFHA) | SC |  | 03 | 12
Preliminaries | Temporary Services | Temporary Power & water: Site Sheds Connections. | SC |  |  | 01
Preliminaries | Temporary Services | Temporary Power & water: Over site | SC |  |  | 02
Preliminaries | Temporary Services | Electricity Connections | SC |  |  | 03
Preliminaries | Temporary Services | Electricity Charges/Tariffs | SC |  |  | 04
Preliminaries | Temporary Services | Telephone Connections | SC |  |  | 05
Preliminaries | Temporary Services | Telephone Charges/Tariffs | SC |  |  | 06
Preliminaries | Temporary Services | Water & Sewer Connections | SC |  |  | 07
Preliminaries | Temporary Services | Water & Sewer Charges/Tariffs | SC |  |  | 08
Preliminaries | Temporary Services | Internet Connection & Support | SC |  |  | 09
Preliminaries | Temporary Services | Internet monthly charges | SC |  |  | 10
Preliminaries | Temporary Services | Site lighting | SC |  |  | 11
Preliminaries | Temporary Services | Monthly lead Checks | SC |  |  | 12
Preliminaries | Access Equipment | EWP / Scissor Lift - Weekly Hire | SC |  |  | 01
Preliminaries | Access Equipment | EWP / Scissor Lift - Transport & Pick-up | SC |  |  | 02
Preliminaries | Access Equipment | Boom Lift - Weekly Hire | SC |  |  | 03
Preliminaries | Access Equipment | Boom Lift - Transport & Pick-up | SC |  |  | 04
Preliminaries | Access Equipment | Mobile Scaffold | SC |  |  | 05
Preliminaries | Access Equipment | Internal Scaffold - Contract | SC |  |  | 06
Preliminaries | Access Equipment | Internal [NAME] | SC |  |  | 07
Preliminaries | Access Equipment | Internal Scaffold Erection | SC |  |  | 08
Preliminaries | Access Equipment | External Scaffold - Contract | SC |  |  | 09
Preliminaries | Access Equipment | External [NAME] | SC |  |  | 10
Preliminaries | Access Equipment | External [NAME] | SC |  |  | 11
Preliminaries | Builder Equipment | Fork Lift - Weekly Hire | SC |  |  | 01
Preliminaries | Builder Equipment | Fork Lift - Transport & Pick-up | SC |  |  | 02
Preliminaries | Builder Equipment | Pallet Jack | SC |  |  | 03
Preliminaries | Builder Equipment | Dewater Pump | SC |  |  | 04
Preliminaries | Builder Equipment | Generator | SC |  |  | 05
Preliminaries | Builder Equipment | Compressor | SC |  |  | 06
Preliminaries | Builder Equipment | Brick/Block Saw | SC |  |  | 07
Preliminaries | Builder Equipment | Small Tools Hire | SC |  |  | 08
Preliminaries | Builder Equipment | Small Tools Purchase | SC |  |  | 09
Preliminaries | Builder Equipment | Builders Sundry Fixings | SC |  |  | 10
Preliminaries | Builder Equipment | Fuel | SC |  |  | 11
Preliminaries | Builder Equipment | Miscellaneous Plant | SC |  |  | 12
Preliminaries | [NAME] | Tower Crane - Contract | SC |  |  | 01
Preliminaries | [NAME] | Mobile Crane - Contract | SC |  |  | 02
Preliminaries | [NAME] | Hoist - Contract | SC |  |  | 03
Preliminaries | [NAME] | Hoist - Material Hire | SC |  |  | 04
Preliminaries | [NAME] | Hoist - Personnel Hire | SC |  |  | 05
Preliminaries | [NAME] | Hoist - Barrow Hire | SC |  |  | 06
Preliminaries | [NAME] | Hoist - Erection & Dismantle | SC |  |  | 07
Preliminaries | [NAME] | [NAME] | SC |  |  | 08
Preliminaries | Off Site Labour | Construction Manager | SC |  |  | 01
Preliminaries | Off Site Labour | Project Manager | SC |  |  | 02
Preliminaries | Off Site Labour | Contract Administrator | SC |  |  | 03
Preliminaries | Off Site Labour | Project Coordinator | SC |  |  | 04
Preliminaries | Off Site Labour | Estimator | SC |  |  | 05
Preliminaries | Off Site Labour | OH&S Officer | SC |  |  | 06
Preliminaries | Shedding and Facilities | Site Sheds - Weekly Hire | SC |  |  | 01
Preliminaries | Shedding and Facilities | Site Sheds - Transport & Pick-up | SC |  |  | 02
Preliminaries | Shedding and Facilities | Site container - Weekly Hire | SC |  |  | 03
Preliminaries | Shedding and Facilities | Site container - Transport & Pick-up | SC |  |  | 04
Preliminaries | Shedding and Facilities | Portaloo - Weekly Hire | SC |  |  | 05
Preliminaries | Shedding and Facilities | Portaloo - Transport & Pick-up | SC |  |  | 06
Preliminaries | Shedding and Facilities | Amenities - Weekly Hire | SC |  |  | 07
Preliminaries | Shedding and Facilities | Amenities - Transport & Pick-up | SC |  |  | 08
Preliminaries | Shedding and Facilities | Build Temp Internal Sheds and remove on completion | SC |  |  | 09
Preliminaries | Shedding and Facilities | Other Rental Accommodation | SC |  |  | 10
Preliminaries | Shedding and Facilities | Car parking | SC |  |  | 11
Preliminaries | Shedding and Facilities | Furniture | SC |  |  | 12
Preliminaries | Shedding and Facilities | Beverages (Tea/Coffee etc.) | SC |  |  | 13
Preliminaries | Shedding and Facilities | Water Coolers | SC |  |  | 14
Preliminaries | Shedding and Facilities | Safety & First Aid Box | SC |  |  | 15
Trades | Tiling | [NAME] | SC |  | 01 | 00
Trades | Concrete Works | [NAME] | SC |  | 02 | 00
Trades | Masonry Repair Work | [NAME] | SC |  | 03 | 00
Trades | Demolition | [NAME] | SC |  | 04 | 00
Trades | Painting | [NAME] | SC |  | 05 | 00
Trades | Stonework | [NAME] | SC |  | 06 | 00
Trades | Carpentry | [NAME] | SC |  | 07 | 00
Trades | Cladding & Rendering | [NAME] | SC |  | 08 | 00
Services | Blinds & Curtains | [NAME] | SC |  | 01 | 00
Services | Balustrading | [NAME] | SC |  | 02 | 00
Services | Blockwork / Brickwork | [NAME] | SC |  | 03 | 00
Services | [NAME] | [NAME] | SC |  | 04 | 00
Services | Ceiling Work | [NAME] | SC |  | 05 | 00
Services | Glass / Glazing | [NAME] | SC |  | 06 | 00
Services | Hydraulic/Plumbing | [NAME] | SC |  | 07 | 00
Services | Demolition | [NAME] | SC |  | 08 | 00
Services | Doors & Windows | [NAME] | SC |  | 09 | 00
Services | [NAME] | [NAME] | SC |  | 10 | 00
Services | Electrical Services | [NAME] | SC |  | 11 | 00
Services | Kitchen | [NAME] | SC |  | 12 | 00
Services | Access Floors | [NAME] | SC |  | 13 | 00
Services | Landscaping / External Works | [NAME] | SC |  | 14 | 00
Services | Fire Services | [NAME] | SC |  | 15 | 00
Services | Mechanical Services | [NAME] | SC |  | 16 | 00
Services | Metal Works | [NAME] | SC |  | 17 | 00
Services | Partitions / Ceilings / Doors | [NAME] | SC |  | 18 | 00
Services | Roofing | [NAME] | SC |  | 19 | 00
Services | Security | [NAME] | SC |  | 20 | 00
Services | Special Doors | [NAME] | SC |  | 21 | 00
Services | Stairs | [NAME] | SC |  | 22 | 00
Services | Structural Works | [NAME] | SC |  | 23 | 00
Services | Toilet Partitions | [NAME] | SC |  | 24 | 00
Services | Waterproofing Work | [NAME] | SC |  | 25 | 00
Consultants | Concrete Scanning | [NAME] | SC |  |  | 00
Consultants | Design | [NAME] | SC |  |  | 00
[NAME] or General | Appliances/Whitegoods | [NAME] | SC |  | 01 | 00
[NAME] or General | Loose Furniture | [NAME] | SC |  | 02 | 00
[NAME] or General | Other | [NAME] | SC |  | 03 | 00