Spreadsheet: 884945d1734344898-automatically-generating-rows-based-subposts-frodo77-forum-21-spill-365-aligw
Sheet: Sheet1

 | Description - desired result |  |  | Table 2 |  |  |  | Table 1
 | Item | Item with sub-posts |  | Number of rows | Item | Reference number |  | Reference number | 1 | 2 | 3 | 4 |  |  |  | Beam01
 | Beam01 | Beam01 |  |  | Beam01 | 1 |  | Number of rows |  |  |  |  |  | Formwork | Beam01 | Formwork
 | Beam01 | Formwork |  |  | [NAME] | 1 |  | Construction-type | Beam | Column | Base slab | Wall |  | Reinforcement | Beam01 | Reinforcement
 | Beam01 | Reinforcement |  |  | Column01 | 2 |  | Sub-post 1 | Formwork | Formwork | Formwork | Formwork |  | Casting | Beam01 | Casting
 | Beam01 | Casting |  |  | Column02 | 2 |  | Sub-post 2 | Reinforcement | Reinforcement | Isolation | Recesses |  | Surface treatment | Beam01 | Surface treatment
 | Beam01 | Surface treatment |  |  | Wall01 | 3 |  | Sub-post 3 | Casting | Test | Plastic | Installation steel plates |  | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] |  |  | Wall02 | 3 |  | Sub-post 4 | Surface treatment | Test | Radon | Reinforcement |  | Formwork | [NAME] | Formwork
 | [NAME] | Formwork |  |  | Beam03 | 1 |  | Sub-post 5 |  | Casting | Reinforcement | Casting |  | Reinforcement | [NAME] | Reinforcement
 | [NAME] | Reinforcement |  |  |  |  |  | Sub-post 13 |  |  | Casting | Surface treatment |  | Casting | [NAME] | Casting
 | [NAME] | Casting |  |  |  |  |  | Sub-post 14 |  |  | Curing |  |  | Surface treatment | [NAME] | Surface treatment
 | [NAME] | Surface treatment |  |  |  |  |  | Sub-post 15 |  |  | Surface treatment |  |  | Column01 | Column01 | Column01
 | Column01 | Column01 |  |  |  |  |  |  |  |  |  |  |  | Formwork | Column01 | Formwork
 | Column01 | Formwork |  | Table 2 must have the ability to be modified any way I want it. This is just the list I get from exported data from a model. (example) |  |  |  |  |  |  |  |  |  | Reinforcement | Column01 | Reinforcement
 | Column01 | Reinforcement |  | Number of rows | Item | Reference number |  |  |  |  |  |  |  | Test | Column01 | Test
 | Column01 | Casting |  |  | Bjelke01 | 1 |  |  |  |  |  |  |  | Test | Column01 | Test
 | Column02 | Column02 |  |  | [NAME] | 1 |  |  |  |  |  |  |  | Casting | Column01 | Casting
 | Column02 | Formwork |  |  | Base slab01 | 3 |  |  |  |  |  |  |  | Column02 | Column02 | Column02
 | Column02 | Reinforcement |  |  | Column01 | 2 |  |  |  |  |  |  |  | Formwork | Column02 | Formwork
 | Column02 | Casting |  |  | Column02 | 2 |  |  |  |  |  |  |  | Reinforcement | Column02 | Reinforcement
 | Wall01 | Wall01 |  |  | Wall01 | 3 |  |  |  |  |  |  |  | Test | Column02 | Test
 | Wall01 | Formwork |  |  | Wall02 | 4 |  |  |  |  |  |  |  | Test | Column02 | Test
 | Wall01 | Recesses |  |  | Beam03 | 1 |  |  |  |  |  |  |  | Casting | Column02 | Casting
 | Wall01 | Installation steel plates |  |  |  |  |  |  |  |  |  |  |  | Wall01 | Wall01 | Wall01
 | Wall01 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  | Formwork | Wall01 | Formwork
 | Wall01 | Casting |  |  |  |  |  |  |  |  |  |  |  | Recesses | Wall01 | Recesses
 | Wall01 | Surface treatment |  |  |  |  |  |  |  |  |  |  |  | Installation steel plates | Wall01 | Installation steel plates
 | Wall02 | Wall01 |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Wall01 | Reinforcement
 | Wall02 | Formwork |  |  |  |  |  |  |  |  |  |  |  | Casting | Wall01 | Casting
 | Wall02 | Recesses |  |  |  |  |  |  |  |  |  |  |  | Surface treatment | Wall01 | Surface treatment
 | Wall02 | Installation steel plates |  |  |  |  |  |  |  |  |  |  |  | Wall02 | Wall02 | Wall02
 | Wall02 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  | Formwork | Wall02 | Formwork
 | Wall02 | Casting |  |  |  |  |  |  |  |  |  |  |  | Recesses | Wall02 | Recesses
 | Wall02 | Surface treatment |  |  |  |  |  |  |  |  |  |  |  | Installation steel plates | Wall02 | Installation steel plates
 | Beam03 | Beam03 |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Wall02 | Reinforcement
 | Beam03 | Formwork |  |  |  |  |  |  |  |  |  |  |  | Casting | Wall02 | Casting
 | Beam03 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  | Surface treatment | Wall02 | Surface treatment
 | Beam03 | Casting |  |  |  |  |  |  |  |  |  |  |  | Beam03 | Beam03 | Beam03
 | Beam03 | Surface treatment |  |  |  |  |  |  |  |  |  |  |  | Formwork | Beam03 | Formwork
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Beam03 | Reinforcement
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Casting | Beam03 | Casting
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Surface treatment | Beam03 | Surface treatment