Hi all,
im not sure if this is a “transpose” problem but i’ve been trying diferent nodes for a while and i cant find a solution…
I have a data sheet with the following scheme:
code | value1 | value2 | value3 | value4 |
---|---|---|---|---|
001 | RED | GREEN | PINK | BLUE |
002 | WHITE | BLACK | ||
003 | WHITE | RED | YELLOW | |
004 | BLUE |
but i need to transform this table, to one like this:
code | value |
---|---|
001 | RED |
001 | GREEN |
001 | PINK |
001 | BLUE |
002 | WHITE |
002 | BLACK |
003 | WHITE |
003 | RED |
003 | YELLOW |
004 | BLUE |
i’ve been serching in the forum too but i havent founded anything similar.
Please, anyone can help me?
Thanks!