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%3Eceldas%20duplicadas%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%3EBuenos%20d%C3%ADas%20a%20todos%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3EC%C3%B3mo%20duplicar%20filas%20seg%C3%BAn%20el%20valor%20de%20las%20celdas.%3C%2FDIV%3E%3CDIV%3EM%C3%A1s%20f%C3%A1cil%20de%20entender%20con%20este%20ejemplo%3A%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAl%20principio%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%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%3CP%3EAl%20final%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%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%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%3EAn%C3%A1lisis%20y%20modelado%20de%20datos%20b%C3%A1sicos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAcceso%20a%20los%20datos%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%20duplicar%20las%20celulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631032%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EEsto%20deber%C3%ADa%20funcionar%2C%20pero%20no%20estoy%20100%25%20seguro%20en%20todos%20los%20casos.%3C%2FP%3E%0A%3CP%3EMesa%20de%20inicio%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.%20Seleccione%20la%20columna%20que%20tiene%20valores%20que%20desea%20separar%3C%2FP%3E%0A%3CP%3E2.%20Con%20la%20columna%20seleccionada%20vaya%20a%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.%20Y%20use%20-%20como%20delimitador.%20presiona%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.%20Vaya%20a%20Tablas%2FPila%3C%2FP%3E%0A%3CP%3E5.%20Agregue%20sus%20nuevas%20columnas%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.%20Pruebe%20qu%C3%A9%20configuraci%C3%B3n%20se%20adapta%20mejor%20a%20su%20caso%20y%20presione%20OK%3C%2FP%3E%0A%3CP%3E7.%20De%20su%20nueva%20tabla%2C%20seleccione%20un%20valor%20vac%C3%ADo%20(si%20hay%20alguno)%20de%20sus%20columnas%20de%20datos%20reci%C3%A9n%20creadas%20y%20elija%20Seleccionar%20celdas%20coincidentes%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.%20Haga%20clic%20derecho%20en%20el%20selector%20de%20filas%20y%20elimine%20filas%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.%20Elimine%20y%20cambie%20el%20nombre%20de%20las%20columnas%20de%20su%20tabla%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

celdas duplicadas

hcarr01
Level VI


Buenos días a todos,

 

Cómo duplicar filas según el valor de las celdas.
Más fácil de entender con este ejemplo:
 
Al principio :
undefined

Al final :

undefined

 

 

Esta publicación fue escrita originalmente en French y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a French .

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: duplicar las celulas

Esto debería funcionar, pero no estoy 100% seguro en todos los casos.

Mesa de inicio

undefined

1. Seleccione la columna que tiene valores que desea separar

2. Con la columna seleccionada vaya a Cols/Utilities/Text to Columns...

undefined

3. Y use - como delimitador. presiona OK

undefined

4. Vaya a Tablas/Pila

5. Agregue sus nuevas columnas a Stack Columns

undefined

6. Pruebe qué configuración se adapta mejor a su caso y presione OK

7. De su nueva tabla, seleccione un valor vacío (si hay alguno) de sus columnas de datos recién creadas y elija Seleccionar celdas coincidentes

undefined

8. Haga clic derecho en el selector de filas y elimine filas

undefined

9. Elimine y cambie el nombre de las columnas de su tabla

undefined

 

1 REPLY 1
jthi
Super User

Re: duplicar las celulas

Esto debería funcionar, pero no estoy 100% seguro en todos los casos.

Mesa de inicio

undefined

1. Seleccione la columna que tiene valores que desea separar

2. Con la columna seleccionada vaya a Cols/Utilities/Text to Columns...

undefined

3. Y use - como delimitador. presiona OK

undefined

4. Vaya a Tablas/Pila

5. Agregue sus nuevas columnas a Stack Columns

undefined

6. Pruebe qué configuración se adapta mejor a su caso y presione OK

7. De su nueva tabla, seleccione un valor vacío (si hay alguno) de sus columnas de datos recién creadas y elija Seleccionar celdas coincidentes

undefined

8. Haga clic derecho en el selector de filas y elimine filas

undefined

9. Elimine y cambie el nombre de las columnas de su tabla

undefined

 

Esta publicación fue escrita originalmente en English (US) y ha sido traducida para su conveniencia. Cuando responda, también se traducirá a English (US).