Spreadsheet: 30146d1225464129-create-a-table-automatically-book1
Sheet: Sheet1

 |  | The table that I have is like this:
 |  | Number | Item A |  |  |  |  | Item B |  |  |  |  | Item C |  |  |  |  | Item D
 |  |  | Unidade 1 | Inidade 2 | Unidade 3 | Unidade 4 | Unidade 5 | Unidade 1 | Inidade 2 | Unidade 3 | Unidade 4 | Unidade 5 | Unidade 1 | Inidade 2 | Unidade 3 | Unidade 4 | Unidade 5 | Unidade 1 | Inidade 2 | Unidade 3 | Unidade 4 | Unidade 5
 |  | 1 | 0 | 0.00999999999839929 | -0.01999999999861757 | -0.00999999999476131 | 0.02000000000043656 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01000000000203727 | -0.01000000000203727 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 127 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 131 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 162 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 210 | 0.01999999999998181 | 0.009999999999990905 | 0.009999999999990905 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 214 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | The final table should be like this:
 |  |  |  |  |  |  |  | Obs.: this table has 4 items and ist big. The original one has 256 rows for each "unidade".
 |  | Número | Item | Unidade | Valor
 |  | 1 | A | 1 | 0
 |  | 26 | A | 1 | 0
 |  | 90 | A | 1 | 0
 |  | 127 | A | 1 | 0
 |  | 131 | A | 1 | 0
 |  | 155 | A | 1 | 0
 |  | 162 | A | 1 | 0
 |  | 183 | A | 1 | 0
 |  | 210 | A | 1 | 0.01999999999998181
 |  | 214 | A | 1 | 0
 |  | 1 | A | 2 | 0.00999999999839929
 |  | 26 | A | 2 | 0
 |  | 90 | A | 2 | 0
 |  | 127 | A | 2 | 0
 |  | 131 | A | 2 | 0
 |  | 155 | A | 2 | 0
 |  | 162 | A | 2 | 0
 |  | 183 | A | 2 | 0
 |  | 210 | A | 2 | 0.009999999999990905
 |  | 214 | A | 2 | 0
 |  | 1 | A | 3 | 0
 |  | 26 | A | 3 | 0
 |  | 90 | A | 3 | 0
 |  | 127 | A | 3 | 0
 |  | 131 | A | 3 | 0
 |  | 155 | A | 3 | 0
 |  | 162 | A | 3 | 0
 |  | 183 | A | 3 | 0
 |  | 210 | A | 3 | 0
 |  | 214 | A | 3 | 0
 |  | 1 | A | 4 | 0
 |  | 26 | A | 4 | 0
 |  | 90 | A | 4 | 0
 |  | 127 | A | 4 | 0
 |  | 131 | A | 4 | 0
 |  | 155 | A | 4 | 0
 |  | 162 | A | 4 | 0
 |  | 183 | A | 4 | 0
 |  | 210 | A | 4 | 0
 |  | 214 | A | 4 | 0
 |  | 1 | B | 1 | 0
 |  | 26 | B | 1 | 0
 |  | 90 | B | 1 | 0
 |  | 127 | B | 1 | 0
 |  | 131 | B | 1 | 0
 |  | 155 | B | 1 | 0
 |  | 162 | B | 1 | 0
 |  | 183 | B | 1 | 0
 |  | 210 | B | 1 | 0
 |  | 214 | B | 1 | 0
 |  | 1 | B | 2 | 0
 |  | 26 | B | 2 | 0
 |  | 90 | B | 2 | 0
 |  | 127 | B | 2 | 0
 |  | 131 | B | 2 | 0
 |  | 155 | B | 2 | 0
 |  | 162 | B | 2 | 0
 |  | 183 | B | 2 | 0
 |  | 210 | B | 2 | 0
 |  | 214 | B | 2 | 0
 |  | 1 | B | 3 | 0
 |  | 26 | B | 3 | 0
 |  | 90 | B | 3 | 0
 |  | 127 | B | 3 | 0
 |  | 131 | B | 3 | 0
 |  | 155 | B | 3 | 0
 |  | 162 | B | 3 | 0
 |  | 183 | B | 3 | 0
 |  | 210 | B | 3 | 0
 |  | 214 | B | 3 | 0
 |  | 1 | B | 4 | 0
 |  | 26 | B | 4 | 0
 |  | 90 | B | 4 | 0
 |  | 127 | B | 4 | 0
 |  | 131 | B | 4 | 0
 |  | 155 | B | 4 | 0
 |  | 162 | B | 4 | 0
 |  | 183 | B | 4 | 0
 |  | 210 | B | 4 | 0
 |  | 214 | B | 4 | 0
 |  | 1 | C | 1 | 0
 |  | 26 | C | 1 | 0
 |  | 90 | C | 1 | 0
 |  | 127 | C | 1 | 0
 |  | 131 | C | 1 | 0
 |  | 155 | C | 1 | 0
 |  | 162 | C | 1 | 0
 |  | 183 | C | 1 | 0
 |  | 210 | C | 1 | 0
 |  | 214 | C | 1 | 0
 |  | 1 | C | 2 | 0
 |  | 26 | C | 2 | 0
 |  | 90 | C | 2 | 0
 |  | 127 | C | 2 | 0
 |  | 131 | C | 2 | 0
 |  | 155 | C | 2 | 0
 |  | 162 | C | 2 | 0
 |  | 183 | C | 2 | 0
 |  | 210 | C | 2 | 0
 |  | 214 | C | 2 | 0
 |  | 1 | C | 3 | 0
 |  | 26 | C | 3 | 0
 |  | 90 | C | 3 | 0
 |  | 127 | C | 3 | 0
 |  | 131 | C | 3 | 0
 |  | 155 | C | 3 | 0
 |  | 162 | C | 3 | 0
 |  | 183 | C | 3 | 0
 |  | 210 | C | 3 | 0
 |  | 214 | C | 3 | 0
 |  | 1 | C | 4 | 0
 |  | 26 | C | 4 | 0
 |  | 90 | C | 4 | 0
 |  | 127 | C | 4 | 0
 |  | 131 | C | 4 | 0
 |  | 155 | C | 4 | 0
 |  | 162 | C | 4 | 0
 |  | 183 | C | 4 | 0
 |  | 210 | C | 4 | 0
 |  | 214 | C | 4 | 0
 |  | 1 | D | 1 | 0
 |  | 26 | D | 1 | 0
 |  | 90 | D | 1 | 0
 |  | 127 | D | 1 | 0
 |  | 131 | D | 1 | 0
 |  | 155 | D | 1 | 0
 |  | 162 | D | 1 | 0
 |  | 183 | D | 1 | 0
 |  | 210 | D | 1 | 0
 |  | 214 | D | 1 | 0
 |  | 1 | D | 2 | 0
 |  | 26 | D | 2 | 0
 |  | 90 | D | 2 | 0
 |  | 127 | D | 2 | 0
 |  | 131 | D | 2 | 0
 |  | 155 | D | 2 | 0
 |  | 162 | D | 2 | 0
 |  | 183 | D | 2 | 0
 |  | 210 | D | 2 | 0
 |  | 214 | D | 2 | 0
 |  | 1 | D | 3 | 0
 |  | 26 | D | 3 | 0
 |  | 90 | D | 3 | 0
 |  | 127 | D | 3 | 0
 |  | 131 | D | 3 | 0
 |  | 155 | D | 3 | 0
 |  | 162 | D | 3 | 0
 |  | 183 | D | 3 | 0
 |  | 210 | D | 3 | 0
 |  | 214 | D | 3 | 0
 |  | 1 | D | 4 | 0
 |  | 26 | D | 4 | 0
 |  | 90 | D | 4 | 0
 |  | 127 | D | 4 | 0
 |  | 131 | D | 4 | 0
 |  | 155 | D | 4 | 0
 |  | 162 | D | 4 | 0
 |  | 183 | D | 4 | 0
 |  | 210 | D | 4 | 0
 |  | 214 | D | 4 | 0