Spreadsheet: 884937d1734337267-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 |  | Chat-gpt
 | Beam01 | Beam01 |  |  | Beam01 | 1 |  | Number of rows |  |  |  |  |  |  |  |  |  | Beam01
 | Beam01 | Formwork |  |  | [NAME] | 1 |  | Construction-type | Beam | Column | Wall |  |  |  |  | Formwork | Beam01 | Formwork
 | Beam01 | Reinforcement |  |  | Column01 | 2 |  | Sub-post 1 | Formwork | Formwork | Formwork |  |  |  |  | Reinforcement | Beam01 | Reinforcement
 | Beam01 | Casting |  |  | Column02 | 2 |  | Sub-post 2 | Reinforcement | Reinforcement | Recesses |  |  |  |  | Casting | Beam01 | Casting
 | Beam01 | Surface treatment |  |  | Wall01 | 3 |  | Sub-post 3 | Casting | Casting | Installation steel plates |  |  |  |  | Surface treatment | Beam01 | Surface treatment
 | [NAME] | [NAME] |  |  | Wall02 | 3 |  | Sub-post 4 | Surface treatment |  | Reinforcement |  |  |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] | Formwork |  |  | Beam03 | 1 |  | Sub-post 5 |  |  | Casting |  |  | <--should be formwork |  | Formwork | [NAME] | Formwork
 | [NAME] | Reinforcement |  |  |  |  |  | Sub-post 6 |  |  | Surface treatment |  |  |  |  | Reinforcement | [NAME] | Reinforcement
 | [NAME] | Casting |  |  |  |  |  | Sub-post 7 |  |  |  |  |  |  |  | Casting | [NAME] | Casting
 | [NAME] | Surface treatment |  |  |  |  |  | Sub-post 8 |  |  |  |  |  |  |  | Surface treatment | [NAME] | Surface treatment
 | Column01 | Column01 |  |  |  |  |  | Sub-post 9 |  |  |  |  |  |  |  | Column01 | Column01 | Column01
 | Column01 | Formwork |  |  |  |  |  | Sub-post 10 |  |  |  |  |  |  |  | Formwork | Column01 | Formwork
 | Column01 | Reinforcement |  |  |  |  |  | Sub-post 11 |  |  |  |  |  |  |  | Reinforcement | Column01 | Reinforcement
 | Column01 | Casting |  |  |  |  |  |  |  |  |  |  |  |  |  | Casting | Column01 | Casting
 | Column02 | Column02 |  |  |  |  |  |  |  |  |  |  |  |  |  | Column02 | Column02 | Column02
 | Column02 | Formwork |  |  |  |  |  |  |  |  |  |  |  |  |  | Formwork | Column02 | Formwork
 | Column02 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Column02 | Reinforcement
 | Column02 | Casting |  |  |  |  |  |  |  |  |  |  |  |  |  | Casting | Column02 | Casting
 | Wall01 | Wall01 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wall01 | Wall01 | Wall01
 | Wall01 | Formwork |  |  |  |  |  |  |  |  |  |  |  |  |  | Formwork | Wall01 | Formwork
 | Wall01 | Recesses |  |  |  |  |  |  |  |  |  |  |  |  |  | Recesses | Wall01 | Recesses
 | Wall01 | Installation steel plates |  |  |  |  |  |  |  |  |  |  |  |  |  | Installation steel plates | Wall01 | Installation steel plates
 | Wall01 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Wall01 | Reinforcement
 | Wall01 | Casting |  |  |  |  |  |  |  |  |  |  |  |  |  | Casting | Wall01 | Casting
 | Wall01 | Surface treatment |  |  |  |  |  |  |  |  |  |  |  |  |  | Surface treatment | Wall01 | Surface treatment
 | Wall02 | Wall01 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wall02 | Wall02 | Wall02
 | Wall02 | Formwork |  |  |  |  |  |  |  |  |  |  |  |  |  | Formwork | Wall02 | Formwork
 | Wall02 | Recesses |  |  |  |  |  |  |  |  |  |  |  |  |  | Recesses | Wall02 | Recesses
 | Wall02 | Installation steel plates |  |  |  |  |  |  |  |  |  |  |  |  |  | Installation steel plates | Wall02 | Installation steel plates
 | Wall02 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Wall02 | Reinforcement
 | Wall02 | Casting |  |  |  |  |  |  |  |  |  |  |  |  |  | Casting | Wall02 | Casting
 | Wall02 | Surface treatment |  |  |  |  |  |  |  |  |  |  |  |  |  | Surface treatment | Wall02 | Surface treatment
 | Beam03 | Beam03 |  |  |  |  |  |  |  |  |  |  |  |  |  | Beam03 | Beam03 | Beam03
 | Beam03 | Formwork |  |  |  |  |  |  |  |  |  |  |  |  |  | Formwork | Beam03 | Formwork
 | Beam03 | Reinforcement |  |  |  |  |  |  |  |  |  |  |  |  |  | Reinforcement | Beam03 | Reinforcement
 | Beam03 | Casting |  |  |  |  |  |  |  |  |  |  |  |  |  | Casting | Beam03 | Casting
 | Beam03 | Surface treatment |  |  |  |  |  |  |  |  |  |  |  |  |  | Surface treatment | Beam03 | Surface treatment