I have an 'Initial Output File' data table that contains a column with both Numeric and Character data in it. This is coded as Character so that the data is available for use as if I make it numeric the character data disappears.
What I want to do is to split this column and create columns that are numeric for numbers and Character for the names,
I've tried various things and can't seem to get this to automatically format the columns like this so that the final output is the same as in the 'required output format'.
I've had a look on the user community and can't see anything to answer my question, but I can't believe that it isn't possible within JMP.