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%3Edoppelte%20Zellen%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%3EHallo%20an%20alle%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3ESo%20duplizieren%20Sie%20Zeilen%20basierend%20auf%20dem%20Wert%20in%20Zellen.%3C%2FDIV%3E%3CDIV%3ELeichter%20zu%20verstehen%20an%20diesem%20Beispiel%3A%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAm%20Anfang%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%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%3CP%3EAm%20Ende%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%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%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%3EGrundlegende%20Datenanalyse%20und%20Modellierung%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDatenzugriff%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%3EBetreff%3A%20dupliquer%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%3EDas%20sollte%20funktionieren%2C%20aber%20ich%20bin%20mir%20nicht%20in%20allen%20F%C3%A4llen%20100%20%25%20sicher%3C%2FP%3E%0A%3CP%3EStarttisch%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.%20W%C3%A4hlen%20Sie%20die%20Spalte%20aus%2C%20deren%20Werte%20Sie%20trennen%20m%C3%B6chten%3C%2FP%3E%0A%3CP%3E2.%20Gehen%20Sie%20bei%20ausgew%C3%A4hlter%20Spalte%20zu%20%E2%80%9ECols%2FUtilities%2FText%20to%20Columns...%E2%80%9C%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.%20Und%20verwenden%20Sie%20-%20als%20Trennzeichen.%20dr%C3%BCcke%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.%20Gehen%20Sie%20zu%20Tabellen%2FStapel%3C%2FP%3E%0A%3CP%3E5.%20F%C3%BCgen%20Sie%20Ihre%20neuen%20Spalten%20zu%20Stack%20Columns%20hinzu%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.%20Versuchen%20Sie%2C%20welche%20Einstellungen%20f%C3%BCr%20Ihren%20Fall%20am%20besten%20passen%2C%20und%20dr%C3%BCcken%20Sie%20OK%3C%2FP%3E%0A%3CP%3E7.%20W%C3%A4hlen%20Sie%20in%20Ihrer%20neuen%20Tabelle%20einen%20leeren%20Wert%20(falls%20vorhanden)%20aus%20Ihren%20neu%20erstellten%20Datenspalten%20aus%20und%20w%C3%A4hlen%20Sie%20%E2%80%9E%C3%9Cbereinstimmende%20Zellen%20ausw%C3%A4hlen%E2%80%9C.%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.%20Klicken%20Sie%20mit%20der%20rechten%20Maustaste%20auf%20die%20Zeilenauswahl%20und%20l%C3%B6schen%20Sie%20Zeilen%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.%20L%C3%B6schen%20Sie%20Spalten%20aus%20Ihrer%20Tabelle%20und%20benennen%20Sie%20sie%20um%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

doppelte Zellen

hcarr01
Level VI


Hallo an alle,

 

So duplizieren Sie Zeilen basierend auf dem Wert in Zellen.
Leichter zu verstehen an diesem Beispiel:
 
Am Anfang :
undefined

Am Ende :

undefined

 

 

Dieser Beitrag wurde ursprünglich in French geschrieben und wurde zu Ihrer Bequemlichkeit übersetzt. Wenn Sie antworten, wird es auch in French übersetzt.

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Betreff: dupliquer les cellules

Das sollte funktionieren, aber ich bin mir nicht in allen Fällen 100 % sicher

Starttisch

undefined

1. Wählen Sie die Spalte aus, deren Werte Sie trennen möchten

2. Gehen Sie bei ausgewählter Spalte zu „Cols/Utilities/Text to Columns...“

undefined

3. Und verwenden Sie - als Trennzeichen. drücke OK

undefined

4. Gehen Sie zu Tabellen/Stapel

5. Fügen Sie Ihre neuen Spalten zu Stack Columns hinzu

undefined

6. Versuchen Sie, welche Einstellungen für Ihren Fall am besten passen, und drücken Sie OK

7. Wählen Sie in Ihrer neuen Tabelle einen leeren Wert (falls vorhanden) aus Ihren neu erstellten Datenspalten aus und wählen Sie „Übereinstimmende Zellen auswählen“.

undefined

8. Klicken Sie mit der rechten Maustaste auf die Zeilenauswahl und löschen Sie Zeilen

undefined

9. Löschen Sie Spalten aus Ihrer Tabelle und benennen Sie sie um

undefined

 

1 REPLY 1
jthi
Super User

Betreff: dupliquer les cellules

Das sollte funktionieren, aber ich bin mir nicht in allen Fällen 100 % sicher

Starttisch

undefined

1. Wählen Sie die Spalte aus, deren Werte Sie trennen möchten

2. Gehen Sie bei ausgewählter Spalte zu „Cols/Utilities/Text to Columns...“

undefined

3. Und verwenden Sie - als Trennzeichen. drücke OK

undefined

4. Gehen Sie zu Tabellen/Stapel

5. Fügen Sie Ihre neuen Spalten zu Stack Columns hinzu

undefined

6. Versuchen Sie, welche Einstellungen für Ihren Fall am besten passen, und drücken Sie OK

7. Wählen Sie in Ihrer neuen Tabelle einen leeren Wert (falls vorhanden) aus Ihren neu erstellten Datenspalten aus und wählen Sie „Übereinstimmende Zellen auswählen“.

undefined

8. Klicken Sie mit der rechten Maustaste auf die Zeilenauswahl und löschen Sie Zeilen

undefined

9. Löschen Sie Spalten aus Ihrer Tabelle und benennen Sie sie um

undefined

 

Dieser Beitrag wurde ursprünglich in English (US) geschrieben und wurde zu Ihrer Bequemlichkeit übersetzt. Wenn Sie antworten, wird es auch in English (US) übersetzt.