I'm looking to 'unpivot' a table, though I'm not sure what the best way of going about it, is. Additionally, the values are separated by a ';'. I've listed a sample of what I'm looking at:
Column_A Column_B Column_C Column_D
000 A;B;C;D 01;02;03;04 X;Y;D;E
001 A;B S;T
002 C 07 S
From that, I'm looking for a way to unpivot it, but also to keep the relations it's currently
Forum:
Programming