How do I select data from a column between two empty rows in JMP?
Oct 14, 2009 3:11 PM(2000 views)
I am trying to select data from a column between two empty rows and paste it another row.(i.e. transpose it). Here is what I have: ---------------------------- Column 1 (empty row) (empty row) 3 4 5 6 7 8 9 (empty row) (empty row) 3 4 5 (empty row) (empty row) 34 6 7 8 (empty row) (empty row) ---------------------
The number of data points between two sets of empty rows is variable. So here is the output I would like to have: ROW1: 3 4 5 6 7 8 9 ROW2: 3 4 5 ROW3: 34 6 7 8
I am a newbie and any help is appreciated. Thanks.
You can use this as the Group column in the Split dialog and you'll get what you want.
However, mpb also points out that once you have this Group column you can use Tables ->Transpose with Column 1 in the Transpose Columns role and Group in the By role. Which means that you don't need the column from my first solution at all.
If you are grep savvy this particular problem may be easier to solve using a text editor. Paste your data in a text editor Find: (\d+)\r Replace with: \1\t Now you have your rows (tab separated) To get rid of empty rows (and the dots representing missing values in jmp in case of continuous variables) Find: \t\.*\r\.* Replace with: nothing Paste back into a new jmp data table. However the trick given above should work as well.