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-630996%22%20slang%3D%22fr-FR%22%20mode%3D%22NONE%22%3E%E9%87%8D%E8%A4%87%E5%96%AE%E5%85%83%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-630996%22%20slang%3D%22fr-FR%22%20mode%3D%22NONE%22%3E%3CP%3E%3CBR%20%2F%3E%3CFONT%3E%E5%A4%A7%E5%AE%B6%E5%A5%BD%EF%BC%8C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%96%AE%E5%85%83%E6%A0%BC%E4%B8%AD%E7%9A%84%E5%80%BC%E8%A4%87%E8%A3%BD%E8%A1%8C%E3%80%82%3C%2FDIV%3E%3CDIV%3E%E7%94%A8%E9%80%99%E5%80%8B%E4%BE%8B%E5%AD%90%E6%9B%B4%E5%AE%B9%E6%98%93%E7%90%86%E8%A7%A3%EF%BC%9A%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%E4%B8%80%E9%96%8B%E5%A7%8B%EF%BC%9A%3C%2FDIV%3E%3CDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hcarr01_0-1683807216180.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1683807216180.png%22%20style%3D%22width%3A%20198px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1683807216180.png%22%20style%3D%22width%3A%20198px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1683807216180.png%22%20style%3D%22width%3A%20198px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1683807216180.png%22%20style%3D%22width%3A%20198px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52726iDE674357FFAD0139%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hcarr01_0-1683807216180.png%22%20alt%3D%22hcarr01_0-1683807216180.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CP%3E%E5%9C%A8%E6%9C%80%E5%BE%8C%20%EF%BC%9A%3C%2FP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hcarr01_1-1683807257731.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1683807257731.png%22%20style%3D%22width%3A%20194px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1683807257731.png%22%20style%3D%22width%3A%20194px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1683807257731.png%22%20style%3D%22width%3A%20194px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1683807257731.png%22%20style%3D%22width%3A%20194px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52727i3B0A735A91DFDF50%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hcarr01_1-1683807257731.png%22%20alt%3D%22hcarr01_1-1683807257731.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-630996%22%20slang%3D%22fr-FR%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E5%9F%BA%E7%A4%8E%E6%95%B8%E6%93%9A%E5%88%86%E6%9E%90%E8%88%87%E5%BB%BA%E6%A8%A1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E6%95%B8%E6%93%9A%E8%A8%AA%E5%95%8F%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-631032%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9Adupliquer%20les%20cellules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631032%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E9%80%99%E6%87%89%E8%A9%B2%E5%8F%AF%E8%A1%8C%EF%BC%8C%E4%BD%86%E6%88%91%E4%B8%8D%E8%83%BD%20100%25%20%E7%A2%BA%E5%AE%9A%E5%9C%A8%E6%89%80%E6%9C%89%E6%83%85%E6%B3%81%E4%B8%8B%3C%2FP%3E%0A%3CP%3E%E8%B5%B7%E5%A7%8B%E8%A1%A8%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1683810765715.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1683810765715.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1683810765715.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52729i0ABD6B34B28EDD0C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1683810765715.png%22%20alt%3D%22jthi_0-1683810765715.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E1.%20%E9%81%B8%E6%93%87%E5%8C%85%E5%90%AB%E8%A6%81%E5%88%86%E9%9A%94%E7%9A%84%E5%80%BC%E7%9A%84%E5%88%97%3C%2FP%3E%0A%3CP%3E2.%20%E9%81%B8%E6%93%87%E5%88%97%E5%BE%8C%E8%BD%89%E5%88%B0%20Cols%2FUtilities%2FText%20to%20Columns...%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1683810795895.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1683810795895.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1683810795895.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52730i8DBE3B783D07C67A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_1-1683810795895.png%22%20alt%3D%22jthi_1-1683810795895.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E3.%20%E4%B8%A6%E4%BD%BF%E7%94%A8%20-%20%E4%BD%9C%E7%82%BA%E5%88%86%E9%9A%94%E7%AC%A6%E3%80%82%20%E6%8C%89%E7%A2%BA%E5%AE%9A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_2-1683810816737.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1683810816737.png%22%20style%3D%22width%3A%20185px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1683810816737.png%22%20style%3D%22width%3A%20185px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52731i490DCBF87EA98901%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_2-1683810816737.png%22%20alt%3D%22jthi_2-1683810816737.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E4.%E8%BD%89%E5%88%B0%E8%A1%A8%2F%E5%A0%86%E6%A3%A7%3C%2FP%3E%0A%3CP%3E5.%20%E5%B0%87%E6%96%B0%E5%88%97%E6%B7%BB%E5%8A%A0%E5%88%B0%20Stack%20Columns%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_3-1683810864243.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_3-1683810864243.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_3-1683810864243.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52732i6E57376998D6FDAD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_3-1683810864243.png%22%20alt%3D%22jthi_3-1683810864243.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E6.%20%E5%98%97%E8%A9%A6%E6%9C%80%E9%81%A9%E5%90%88%E6%82%A8%E6%83%85%E6%B3%81%E7%9A%84%E8%A8%AD%E7%BD%AE%EF%BC%8C%E7%84%B6%E5%BE%8C%E6%8C%89%20OK%3C%2FP%3E%0A%3CP%3E7.%20%E5%9C%A8%E6%96%B0%E8%A1%A8%E4%B8%AD%EF%BC%8C%E5%BE%9E%E6%96%B0%E5%89%B5%E5%BB%BA%E7%9A%84%E6%95%B8%E6%93%9A%E5%88%97%E4%B8%AD%E9%81%B8%E6%93%87%E4%B8%80%E5%80%8B%E7%A9%BA%E5%80%BC%EF%BC%88%E5%A6%82%E6%9E%9C%E6%9C%89%EF%BC%89%EF%BC%8C%E7%84%B6%E5%BE%8C%E9%81%B8%E6%93%87%E2%80%9C%E9%81%B8%E6%93%87%E5%8C%B9%E9%85%8D%E5%96%AE%E5%85%83%E6%A0%BC%E2%80%9D%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_4-1683810923897.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_4-1683810923897.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_4-1683810923897.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52733i5F4545743391CD65%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_4-1683810923897.png%22%20alt%3D%22jthi_4-1683810923897.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E8.%E5%8F%B3%E9%8D%B5%E5%96%AE%E6%93%8A%E8%A1%8C%E9%81%B8%E6%93%87%E5%99%A8%E4%B8%A6%E5%88%AA%E9%99%A4%E8%A1%8C%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_5-1683810942915.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_5-1683810942915.png%22%20style%3D%22width%3A%20313px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_5-1683810942915.png%22%20style%3D%22width%3A%20313px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52734i0EB80FE54D08613F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_5-1683810942915.png%22%20alt%3D%22jthi_5-1683810942915.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E9.%20%E5%BE%9E%E8%A1%A8%E4%B8%AD%E5%88%AA%E9%99%A4%E5%92%8C%E9%87%8D%E5%91%BD%E5%90%8D%E5%88%97%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_6-1683810968419.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_6-1683810968419.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_6-1683810968419.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F52735i5BC2A264D9450DE6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_6-1683810968419.png%22%20alt%3D%22jthi_6-1683810968419.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

重複單元格

hcarr01
Level VI


大家好,

 

如何根據單元格中的值複製行。
用這個例子更容易理解:
 
一開始:
undefined

在最後 :

undefined

 

 

本文原文为French 撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回French 。

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

回复:dupliquer les cellules

這應該可行,但我不能 100% 確定在所有情況下

起始表

undefined

1. 選擇包含要分隔的值的列

2. 選擇列後轉到 Cols/Utilities/Text to Columns...

undefined

3. 並使用 - 作為分隔符。 按確定

undefined

4.轉到表/堆棧

5. 將新列添加到 Stack Columns

undefined

6. 嘗試最適合您情況的設置,然後按 OK

7. 在新表中,從新創建的數據列中選擇一個空值(如果有),然後選擇“選擇匹配單元格”

undefined

8.右鍵單擊行選擇器並刪除行

undefined

9. 從表中刪除和重命名列

undefined

 

1 REPLY 1
jthi
Super User

回复:dupliquer les cellules

這應該可行,但我不能 100% 確定在所有情況下

起始表

undefined

1. 選擇包含要分隔的值的列

2. 選擇列後轉到 Cols/Utilities/Text to Columns...

undefined

3. 並使用 - 作為分隔符。 按確定

undefined

4.轉到表/堆棧

5. 將新列添加到 Stack Columns

undefined

6. 嘗試最適合您情況的設置,然後按 OK

7. 在新表中,從新創建的數據列中選擇一個空值(如果有),然後選擇“選擇匹配單元格”

undefined

8.右鍵單擊行選擇器並刪除行

undefined

9. 從表中刪除和重命名列

undefined

 

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。