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%3E%E5%88%97%E5%86%85%E3%81%A7%E3%83%95%E3%82%A3%E3%83%AB%E3%82%BF%E3%83%AA%E3%83%B3%E3%82%B0%E3%81%95%E3%82%8C%E3%81%9F%E8%A4%87%E6%95%B0%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773793%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E3%81%93%E3%82%93%E3%81%AB%E3%81%A1%E3%81%AF%E3%80%81%E7%9A%86%E3%81%95%E3%82%93%E3%80%81%E3%81%94%E5%8D%94%E5%8A%9B%E3%81%84%E3%81%9F%E3%81%A0%E3%81%91%E3%82%8C%E3%81%B0%E5%B9%B8%E3%81%84%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3EExcel%20%E3%81%8B%E3%82%89%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%97%E3%81%9F%E5%88%97%E3%81%AB%E4%BD%95%E5%8D%83%E3%82%82%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%82%8C%E3%82%89%E3%81%AE%E5%88%97%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AB%E3%81%AF%E3%80%812%20%E3%81%A4%E3%81%AE%E5%90%8D%E5%89%8D%E3%81%A8%E7%B4%84%207%20%E3%81%A4%E3%81%AE%E7%95%B0%E3%81%AA%E3%82%8B%E3%83%A9%E3%83%99%E3%83%AB%E7%95%AA%E5%8F%B7%E3%81%8C%E6%B7%B7%E5%9C%A8%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E4%B8%8D%E8%A6%81%E3%81%AA%E4%BB%96%E3%81%AE%E5%90%8D%E5%89%8D%E3%82%92%E3%83%95%E3%82%A3%E3%83%AB%E3%82%BF%E3%83%BC%E3%81%97%E3%81%A6%E3%80%81%E3%80%8C%E9%9D%9E%E8%A1%A8%E7%A4%BA%E3%81%AB%E3%81%97%E3%81%A6%E9%99%A4%E5%A4%96%E3%80%8D%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%E7%8F%BE%E5%9C%A8%E3%80%81%E3%81%93%E3%81%AE%207%20%E3%81%A4%E3%81%AE%E7%95%B0%E3%81%AA%E3%82%8B%E7%95%AA%E5%8F%B7%E3%82%92%201%20%E3%81%A4%E3%81%AE%E5%90%8D%E5%89%8D%E3%81%A7%E3%81%A9%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E5%88%86%E9%A1%9E%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%8B%E5%9B%B0%E3%81%A3%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%82%8C%E3%82%89%E3%81%99%E3%81%B9%E3%81%A6%E3%81%8C%E5%AE%8C%E4%BA%86%E3%81%97%E3%81%9F%E3%82%89%E3%80%81%E3%82%B0%E3%83%A9%E3%83%95%20%E3%83%93%E3%83%AB%E3%83%80%E3%83%BC%E3%82%92%E5%AE%9F%E8%A1%8C%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%BC%E3%83%B3%E3%81%A8%E3%81%97%E3%81%A6%E5%8A%A9%E3%81%91%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%84%E3%80%82%E3%82%88%E3%82%8D%E3%81%97%E3%81%8F%E3%81%8A%E9%A1%98%E3%81%84%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%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%3E%E3%82%B3%E3%83%B3%E3%83%86%E3%83%B3%E3%83%84%E3%81%AE%E6%A7%8B%E6%88%90%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E3%83%9E%E3%82%B9%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%9E%E3%82%A4%E3%82%BC%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E3%82%A6%E3%82%A3%E3%83%B3%E3%83%89%E3%82%A6%E3%82%BA%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%20%E5%88%97%E5%86%85%E3%81%A7%E3%83%95%E3%82%A3%E3%83%AB%E3%82%BF%E3%83%AA%E3%83%B3%E3%82%B0%E3%81%95%E3%82%8C%E3%81%9F%E8%A4%87%E6%95%B0%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773815%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ERecode%20%E3%83%97%E3%83%A9%E3%83%83%E3%83%88%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%82%92%E8%A9%A6%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%81%8B%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%3EJMP%E3%81%AE%E4%BD%BF%E7%94%A8%20%26gt%3B%20%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%85%A5%E5%8A%9B%E3%81%A8%E7%B7%A8%E9%9B%86%20%26gt%3B%20%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%86%8D%E6%A7%8B%E7%AF%89%3C%2FA%3E%20%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%3EJMP%20%E3%81%AE%E4%BD%BF%E7%94%A8%20%26gt%3B%20%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%85%A5%E5%8A%9B%E3%81%A8%E7%B7%A8%E9%9B%86%20%26gt%3B%20%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%86%8D%E6%A7%8B%E6%88%90%20%26gt%3B%20%E5%88%97%E5%86%85%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%86%8D%E3%82%B3%E3%83%BC%E3%83%89%E5%8C%96%3C%2FA%3E%20%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%20%E5%88%97%E5%86%85%E3%81%A7%E3%83%95%E3%82%A3%E3%83%AB%E3%82%BF%E3%83%AA%E3%83%B3%E3%82%B0%E3%81%95%E3%82%8C%E3%81%9F%E8%A4%87%E6%95%B0%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774023%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E3%81%93%E3%82%93%E3%81%AB%E3%81%A1%E3%81%AF%E3%80%81Jarmo%20%E3%81%95%E3%82%93%E3%80%82%E6%9C%AC%E5%BD%93%E3%81%AB%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%81%94%E3%81%96%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%81%AE%202%20%E3%81%A4%E3%81%AE%E3%83%97%E3%83%A9%E3%83%83%E3%83%88%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%81%8C%E5%95%8F%E9%A1%8C%E8%A7%A3%E6%B1%BA%E3%81%AB%E5%BD%B9%E7%AB%8B%E3%81%A1%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%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!