cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-773793%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EMultiple%20Data%20Filtered%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773793%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHi%20guys%2C%20would%20really%20appreciate%20your%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20thousands%20of%20data%20in%20a%20column%20that%20i%20imported%20from%20excel.%20These%20column%20data%20has%20a%20mixture%20of%202%20names%20and%20about%207%20different%20label%20numbers.%20I%20have%20filter%20out%20the%20other%20names%20which%20i%20do%20not%20want%20and%20%22hide%20and%20exclude%22.%20Now%20i%20am%20stuck%20with%20how%20do%20i%20categorized%20these%207%20different%20numbers%20under%20this%20one%20name.%20I%20will%20need%20to%20do%20graph%20builder%20after%20all%20these%20is%20done.%20Please%20help%20an%20out%20an%20intern%20here%2C%20much%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-773793%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EContent%20Organization%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMass%20Customization%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773815%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Multiple%20Data%20Filtered%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773815%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHave%20you%20tried%20Recode%20platform%3F%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.0%2F%23page%2Fjmp%2Frestructure-data.shtml%23%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUsing%20JMP%20%26gt%3B%20Enter%20and%20Edit%20Your%20Data%20%26gt%3B%20Restructure%20Data%3C%2FA%3E%26nbsp%3B%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.0%2F%23page%2Fjmp%2Frecode-data-in-a-column.shtml%23ww791384%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUsing%20JMP%20%26gt%3B%20Enter%20and%20Edit%20Your%20Data%20%26gt%3B%20Restructure%20Data%20%26gt%3B%20Recode%20Data%20in%20a%20Column%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774023%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Multiple%20Data%20Filtered%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774023%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHi%20Jarmo%2C%20thank%20you%20so%20much%2C%20these%202%20platforms%20have%20helped%20me%20solve%20the%20issue!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Multiple Data Filtered in a column

Hi guys, would really appreciate your help. 

I have thousands of data in a column that i imported from excel. These column data has a mixture of 2 names and about 7 different label numbers. I have filter out the other names which i do not want and "hide and exclude". Now i am stuck with how do i categorized these 7 different numbers under this one name. I will need to do graph builder after all these is done. Please help an out an intern here, much thanks!

2 REPLIES 2
jthi
Super User

Re: Multiple Data Filtered in a column

Re: Multiple Data Filtered in a column

Hi Jarmo, thank you so much, these 2 platforms have helped me solve the issue!