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%3Ecellule%20duplicate%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%3EBuongiorno%20a%20tutti%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3ECome%20duplicare%20le%20righe%20in%20base%20al%20valore%20nelle%20celle.%3C%2FDIV%3E%3CDIV%3EPi%C3%B9%20facile%20da%20capire%20con%20questo%20esempio%3A%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAll'inizio%20%3A%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%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%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%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CP%3EAlla%20fine%20%3A%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%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%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%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%3EAnalisi%20e%20modellazione%20dei%20dati%20di%20base%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccesso%20ai%20dati%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%3ERe%3A%20duplicare%20le%20cellule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631032%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EQuesto%20dovrebbe%20funzionare%2C%20ma%20non%20sono%20sicuro%20al%20100%25%20in%20tutti%20i%20casi%3C%2FP%3E%0A%3CP%3ETabella%20di%20partenza%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.%20Selezionare%20la%20colonna%20che%20contiene%20i%20valori%20che%20si%20desidera%20separare%3C%2FP%3E%0A%3CP%3E2.%20Con%20la%20colonna%20selezionata%20vai%20su%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.%20E%20usa%20-%20come%20delimitatore.%20premere%20OK%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.%20Vai%20a%20Tabelle%2FPila%3C%2FP%3E%0A%3CP%3E5.%20Aggiungi%20le%20tue%20nuove%20colonne%20a%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.%20Prova%20quali%20impostazioni%20si%20adattano%20meglio%20al%20tuo%20caso%20e%20premi%20OK%3C%2FP%3E%0A%3CP%3E7.%20Dalla%20nuova%20tabella%2C%20seleziona%20un%20valore%20vuoto%20(se%20ce%20ne%20sono)%20dalle%20colonne%20di%20dati%20appena%20create%20e%20scegli%20Seleziona%20celle%20corrispondenti%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.%20Fare%20clic%20con%20il%20tasto%20destro%20sul%20selettore%20di%20riga%20ed%20eliminare%20le%20righe%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.%20Elimina%20e%20rinomina%20le%20colonne%20dalla%20tua%20tabella%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

cellule duplicate

hcarr01
Level VI


Buongiorno a tutti,

 

Come duplicare le righe in base al valore nelle celle.
Più facile da capire con questo esempio:
 
All'inizio :
undefined

Alla fine :

undefined

 

 

Questo post è stato originariamente scritto in French ed è stato tradotto per comodità. Quando risponderai, verrà anche tradotto in French .

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: duplicare le cellule

Questo dovrebbe funzionare, ma non sono sicuro al 100% in tutti i casi

Tabella di partenza

undefined

1. Selezionare la colonna che contiene i valori che si desidera separare

2. Con la colonna selezionata vai su Cols/Utilities/Text to Columns...

undefined

3. E usa - come delimitatore. premere OK

undefined

4. Vai a Tabelle/Pila

5. Aggiungi le tue nuove colonne a Stack Columns

undefined

6. Prova quali impostazioni si adattano meglio al tuo caso e premi OK

7. Dalla nuova tabella, seleziona un valore vuoto (se ce ne sono) dalle colonne di dati appena create e scegli Seleziona celle corrispondenti

undefined

8. Fare clic con il tasto destro sul selettore di riga ed eliminare le righe

undefined

9. Elimina e rinomina le colonne dalla tua tabella

undefined

 

1 REPLY 1
jthi
Super User

Re: duplicare le cellule

Questo dovrebbe funzionare, ma non sono sicuro al 100% in tutti i casi

Tabella di partenza

undefined

1. Selezionare la colonna che contiene i valori che si desidera separare

2. Con la colonna selezionata vai su Cols/Utilities/Text to Columns...

undefined

3. E usa - come delimitatore. premere OK

undefined

4. Vai a Tabelle/Pila

5. Aggiungi le tue nuove colonne a Stack Columns

undefined

6. Prova quali impostazioni si adattano meglio al tuo caso e premi OK

7. Dalla nuova tabella, seleziona un valore vuoto (se ce ne sono) dalle colonne di dati appena create e scegli Seleziona celle corrispondenti

undefined

8. Fare clic con il tasto destro sul selettore di riga ed eliminare le righe

undefined

9. Elimina e rinomina le colonne dalla tua tabella

undefined

 

Questo post è stato originariamente scritto in English (US) ed è stato tradotto per comodità. Quando risponderai, verrà anche tradotto in English (US).