I like a lean table editor, and was wondering if XTabulator can do either of these frequently required functions: split and stack.
A stack takes columns of data and stacks them so that
Row#,C1,C2,C3
1,2,3,4
2,5,6,7
Becomes
Row#,Label,Content
1,C1,2
1,C2,3
1,C3,4
2,C1,5
2,C2,6
2,C3,7
And split does the reverse, where new columns are created for different values of Label column.
I have this capability in a stats program (JMP), but it is the complete example of using a bulldozer to push peas onto my fork.
Is there a way to script this into the application?
Thanks,
Mark Shelly
infectiologue A T gmail DOT com