Forum Discussion
Solved
Transformar tabla verticalmente
¡Hola chicos!
¿Cómo puedo hacer esto...
| Código | TOTAL "A" | TOTAL "B" | TOTAL "C" |
| LT01 | 5 | -1 | 0 |
| LT02 | 4 | -2 | 0 |
| LT03 | 3 | -3 | 0 |
| LT04 | 2 | -4 | 0 |
en esto?
| Código | Columna | Total |
| LT01 | TOTAL "A" | 5 |
| LT02 | TOTAL "A" | 4 |
| LT03 | TOTAL "A" | 3 |
| LT04 | TOTAL "A" | 2 |
| LT01 | TOTAL "B" | -1 |
| LT02 | TOTAL "B" | -2 |
| LT03 | TOTAL "B" | -3 |
| LT04 | TOTAL "B" | -4 |
| LT01 | TOTAL "C" | 0 |
| LT02 | TOTAL "C" | 0 |
| LT03 | TOTAL "C" | 0 |
| LT04 | TOTAL "C" | 0 |
¡Muchas gracias!
2 Replies
- Greg_Deckler
Community Champion
Haga clic con el botón derecho en la columna CODE en Power Query y elija Unpivot other columns.
- amitchandak
Super User
