Hi - I have 5 groups of 57 columns (5 x 57) that I need to rearrange so that likes are with likes. I've cut and pasted examples of the columns from my JMP table. The columns names have five sets of prefixes (again, each of these groups has 57 column names corresponding to chemical compounds):
1 - RES_VALUES_
2 - RES_TEXT_
3 - DETECT_FLAG_
4 - RL_
5 - DILUTION_FACTOR_
Each of these is followed by a suffix corresponding to the chemical compound name (there are 57 of these).
I want to have each chemical compound name grouped together. So, for example, one chemical compound, say "4:2 FTS", would be listed in the column order as follows: RES_VALUE_4:2 FTS, RES_TEXT_4:2 FTS, DETECT_FLAG_4:2 FTS, RL_4:2 FTS, DILUTION_FACTOR_4:2 FTS. This sequence would be repeated for each chemical compound. What I would end up with is a table that I can easily explore, where the relevant info for each compound is together. The first 5 columns would be 4:2 FTS. The second 5 would be the next compound, 6:2 FTS. And so on.
Is there an efficient way to do this rather than drag and drop? Thanks in advance!
