Spreadsheet: 844879d1696513230-separated-multiple-column-data-separated-fill-in-multiple
Sheet: Sheet1

 | Data |  |  |  | need to separated |  |  |  | Target Result |  |  |  |  |  |  | separated one by one
 |  |  |  |  |  |  |  |  | still manual using choosecols to separated data column 1, 2, and 3
 | Text 1 |  |  |  |  | Text 5, 4 | Text 10, 12 |  |  | 1 | Text 5 | 4 | Text 10 | 12 |  |  | 1 |  | 4 |  | 12
 |  | Text 4 |  |  | Text 1, 2 | Text 4, 6 | Text 10, 13 |  | Text 1 | 2 | Text 4 | 6 | Text 10 | 13 |  | Text 1 | 2 | Text 4 | 6 | Text 10 | 13
 |  |  | Text 5 |  | Text 1, 3 | Text 4, 7 | Text 5, 5 |  | Text 1 | 3 | Text 4 | 7 | Text 5 | 5 |  | Text 1 | 3 | Text 4 | 7 | Text 5 | 5
 | Text 2 |  |  |  | Text 2, 1 | Text 4, 8 | Text 5, 6 |  | Text 2 | 1 | Text 4 | 8 | Text 5 | 6 |  | Text 2 | 1 | Text 4 | 8 | Text 5 | 6
 |  | subt |  |  | Text 2, 2 | Text 4, 9 | Text 5, 7 |  | Text 2 | 2 | Text 4 | 9 | Text 5 | 7 |  | Text 2 | 2 | Text 4 | 9 | Text 5 | 7
 |  |  |  |  | Text 2, 3 | Text 4, 10 | Text 5, 8 |  | Text 2 | 3 | Text 4 | 10 | Text 5 | 8 |  | Text 2 | 3 | Text 4 | 10 | Text 5 | 8
 | Text 3 |  | Text 1000 |  | Text 3, 1 | Text 4, 11 | Text 1000, 1 |  | Text 3 | 1 | Text 4 | 11 | Text 1000 | 1 |  | Text 3 | 1 | Text 4 | 11 | Text 1000 | 1
 |  | Text 10 |  |  | Text 3, 2 | Text 10, 1 | Text 1000, 2 |  | Text 3 | 2 | Text 10 | 1 | Text 1000 | 2 |  | Text 3 | 2 | Text 10 | 1 | Text 1000 | 2
 | subt |  |  |  | Text 3, 3 | Text 10, 2 | Text 1000, 3 |  | Text 3 | 3 | Text 10 | 2 | Text 1000 | 3 |  | Text 3 | 3 | Text 10 | 2 | Text 1000 | 3
 |  |  |  |  | Text 3, 4 | Text 10, 3 | Text 1000, 4 |  | Text 3 | 4 | Text 10 | 3 | Text 1000 | 4 |  | Text 3 | 4 | Text 10 | 3 | Text 1000 | 4
 | Text 4 |  |  |  | Text 4, 1 | Text 10, 4 | Text 1000, 5 |  | Text 4 | 1 | Text 10 | 4 | Text 1000 | 5 |  | Text 4 | 1 | Text 10 | 4 | Text 1000 | 5
 |  |  | Text 10 |  | Text 4, 2 | Text 10, 5 | Text 10, 14 |  | Text 4 | 2 | Text 10 | 5 | Text 10 | 14 |  | Text 4 | 2 | Text 10 | 5 | Text 10 | 14
 | subt |  |  |  | Text 4, 3 | Text 10, 6 | Text 10, 15 |  | Text 4 | 3 | Text 10 | 6 | Text 10 | 15 |  | Text 4 | 3 | Text 10 | 6 | Text 10 | 15
 |  |  |  |  | Text 4, 4 | Text 10, 7 | Text 10, 16 |  | Text 4 | 4 | Text 10 | 7 | Text 10 | 16 |  | Text 4 | 4 | Text 10 | 7 | Text 10 | 16
 |  |  |  |  | Text 4, 5 | Text 10, 8 | Text 10, 17 |  | Text 4 | 5 | Text 10 | 8 | Text 10 | 17 |  | Text 4 | 5 | Text 10 | 8 | Text 10 | 17
 | Text 5 |  |  |  | Text 5, 1 | Text 10, 9 | Text 10, 18 |  | Text 5 | 1 | Text 10 | 9 | Text 10 | 18 |  | Text 5 | 1 | Text 10 | 9 | Text 10 | 18
 |  |  |  |  | Text 5, 2 | Text 10, 10 | Text 10, 19 |  | Text 5 | 2 | Text 10 | 10 | Text 10 | 19 |  | Text 5 | 2 | Text 10 | 10 | Text 10 | 19
 |  |  |  |  | Text 5, 3 | Text 10, 11 | Text 10, 20 |  | Text 5 | 3 | Text 10 | 11 | Text 10 | 20 |  | Text 5 | 3 | Text 10 | 11 | Text 10 | 20
 |  |  |  |  |  | 1 | Text 5 | 4 | Text 10 | 12
 |  |  |  |  | Text 1 | 2 | Text 4 | 6 | Text 10 | 13
 |  |  |  |  | Text 1 | 3 | Text 4 | 7 | Text 5 | 5
 |  |  |  |  | Text 2 | 1 | Text 4 | 8 | Text 5 | 6
 |  |  |  |  | Text 2 | 2 | Text 4 | 9 | Text 5 | 7
 |  |  |  |  | Text 2 | 3 | Text 4 | 10 | Text 5 | 8
 |  |  |  |  | Text 3 | 1 | Text 4 | 11 | Text 1000 | 1
 |  |  |  |  | Text 3 | 2 | Text 10 | 1 | Text 1000 | 2
 |  |  |  |  | Text 3 | 3 | Text 10 | 2 | Text 1000 | 3
 |  |  |  |  | Text 3 | 4 | Text 10 | 3 | Text 1000 | 4
 |  |  |  |  | Text 4 | 1 | Text 10 | 4 | Text 1000 | 5
 |  |  |  |  | Text 4 | 2 | Text 10 | 5 | Text 10 | 14
 |  |  |  |  | Text 4 | 3 | Text 10 | 6 | Text 10 | 15
 |  |  |  |  | Text 4 | 4 | Text 10 | 7 | Text 10 | 16
 |  |  |  |  | Text 4 | 5 | Text 10 | 8 | Text 10 | 17
 |  |  |  |  | Text 5 | 1 | Text 10 | 9 | Text 10 | 18
 |  |  |  |  | Text 5 | 2 | Text 10 | 10 | Text 10 | 19
 |  |  |  |  | Text 5 | 3 | Text 10 | 11 | Text 10 | 20