Spreadsheet: 884961d1734361341-automatically-generating-rows-based-subposts-frodo77-forum-21-spill-365-aligw-2-
Sheet: Example

 | Description - desired result |  |  |  |  |  | Reference numbers | 1 | 2 | 3 | 4 | 5
 | Item | Item with sub-posts |  | Reference numbers | Item |  |  | Bjelke | Beam | Column | Base slab | Wall
 | Beam01 | Beam01 |  | 1 | Bjelke01 |  |  | Test | Formwork | Formwork | Formwork | Formwork
 | Beam01 | Formwork |  | 4 | Base slab01 |  |  | Test2 | Reinforcement | Reinforcement | Isolation | Recesses
 | Beam01 | Reinforcement |  | 3 | Column01 |  |  | Test3 | Casting | Test | Plastic | Installation steel plates
 | Beam01 | Casting |  | 5 | Wall01 |  |  |  | Surface treatment | Test | Radon | Reinforcement
 | Beam01 | Surface treatment |  | 5 | Wall02 |  |  |  |  | Casting | Reinforcement | Casting
 | [NAME] | [NAME] |  | 5 | EXTWall01 |  |  |  |  |  | Casting | Surface treatment
 | [NAME] | Formwork |  | 2 | Beam03 |  |  |  |  |  | Curing
 | [NAME] | Reinforcement |  |  |  |  |  |  |  |  | Surface treatment
 | [NAME] | Casting
 | [NAME] | Surface treatment
 | Column01 | Column01
 | Column01 | Formwork
 | Column01 | Reinforcement
 | Column01 | Casting
 | Column02 | Column02
 | Column02 | Formwork
 | Column02 | Reinforcement |  |  |  |  |  |  | Bjelke01 |  |  | Bjelke01
 | Column02 | Casting |  |  |  |  |  | Bjelke01 | Test |  | Bjelke01 | Test
 | Wall01 | Wall01 |  |  |  |  |  | Bjelke01 | Test2 |  | Bjelke01 | Test2
 | Wall01 | Formwork |  |  |  |  |  | Bjelke01 | Test3 |  | Bjelke01 | Test3
 | Wall01 | Recesses |  |  |  |  |  | Base slab01 | Base slab01 |  | Base slab01 | Base slab01
 | Wall01 | Installation steel plates |  |  |  |  |  | Base slab01 | Formwork |  | Base slab01 | Formwork
 | Wall01 | Reinforcement |  |  |  |  |  | Base slab01 | Isolation |  | Base slab01 | Isolation
 | Wall01 | Casting |  |  |  |  |  | Base slab01 | Plastic |  | Base slab01 | Plastic
 | Wall01 | Surface treatment |  |  |  |  |  | Base slab01 | Radon |  | Base slab01 | Radon
 | Wall02 | Wall01 |  |  |  |  |  | Base slab01 | Reinforcement |  | Base slab01 | Reinforcement
 | Wall02 | Formwork |  |  |  |  |  | Base slab01 | Casting |  | Base slab01 | Casting
 | Wall02 | Recesses |  |  |  |  |  | Base slab01 | Curing |  | Base slab01 | Curing
 | Wall02 | Installation steel plates |  |  |  |  |  | Base slab01 | Surface treatment |  | Base slab01 | Surface treatment
 | Wall02 | Reinforcement |  |  |  |  |  | Column01 | Column01 |  | Column01 | Column01
 | Wall02 | Casting |  |  |  |  |  | Column01 | Formwork |  | Column01 | Formwork
 | Wall02 | Surface treatment |  |  |  |  |  | Column01 | Reinforcement |  | Column01 | Reinforcement
 | Beam03 | Beam03 |  |  |  |  |  | Column01 | Test |  | Column01 | Test
 | Beam03 | Formwork |  |  |  |  |  | Column01 | Test |  | Column01 | Test
 | Beam03 | Reinforcement |  |  |  |  |  | Column01 | Casting |  | Column01 | Casting
 | Beam03 | Casting |  |  |  |  |  | Wall01 | Wall01 |  | Wall01 | Wall01
 | Beam03 | Surface treatment |  |  |  |  |  | Wall01 | Formwork |  | Wall01 | Formwork
 |  |  |  |  |  |  |  | Wall01 | Recesses |  | Wall01 | Recesses
 |  |  |  |  |  |  |  | Wall01 | Installation steel plates |  | Wall01 | Installation steel plates
 |  |  |  |  |  |  |  | Wall01 | Reinforcement |  | Wall01 | Reinforcement
 |  |  |  |  |  |  |  | Wall01 | Casting |  | Wall01 | Casting
 |  |  |  |  |  |  |  | Wall01 | Surface treatment |  | Wall01 | Surface treatment
 |  |  |  |  |  |  |  | Wall02 | Wall02 |  | Wall01 | Wall01
 |  |  |  |  |  |  |  | Wall02 | Formwork |  | Wall01 | Formwork
 |  |  |  |  |  |  |  | Wall02 | Recesses |  | Wall01 | Recesses
 |  |  |  |  |  |  |  | Wall02 | Installation steel plates |  | Wall01 | Installation steel plates
 |  |  |  |  |  |  |  | Wall02 | Reinforcement |  | Wall01 | Reinforcement
 |  |  |  |  |  |  |  | Wall02 | Casting |  | Wall01 | Casting
 |  |  |  |  |  |  |  | Wall02 | Surface treatment |  | Wall01 | Surface treatment
 |  |  |  |  |  |  |  | EXTWall01 | EXTWall01 |  | Wall01 | Wall01
 |  |  |  |  |  |  |  | EXTWall01 | Formwork |  | Wall01 | Formwork
 |  |  |  |  |  |  |  | EXTWall01 | Recesses |  | Wall01 | Recesses
 |  |  |  |  |  |  |  | EXTWall01 | Installation steel plates |  | Wall01 | Installation steel plates
 |  |  |  |  |  |  |  | EXTWall01 | Reinforcement |  | Wall01 | Reinforcement
 |  |  |  |  |  |  |  | EXTWall01 | Casting |  | Wall01 | Casting
 |  |  |  |  |  |  |  | EXTWall01 | Surface treatment |  | Wall01 | Surface treatment
 |  |  |  |  |  |  |  | Beam03 | Beam03 |  | Beam03 | Beam03
 |  |  |  |  |  |  |  | Beam03 | Formwork |  | Beam03 | Formwork
 |  |  |  |  |  |  |  | Beam03 | Reinforcement |  | Beam03 | Reinforcement
 |  |  |  |  |  |  |  | Beam03 | Casting |  | Beam03 | Casting
 |  |  |  |  |  |  |  | Beam03 | Surface treatment |  | Beam03 | Surface treatment