https://community.jmp.com/t5/Discussions/dupliquer-les-cellules/m-p/631032#M82926 <P>This should work, but I'm not 100% sure in all the cases</P> <P>Starting table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1683810765715.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52729i0ABD6B34B28EDD0C/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1683810765715.png" alt="jthi_0-1683810765715.png" /></span></P> <P>1. Select the column that has values you want to separate</P> <P>2. With the column selected go to Cols/Utilities/Text to Columns...</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1683810795895.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52730i8DBE3B783D07C67A/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1683810795895.png" alt="jthi_1-1683810795895.png" /></span></P> <P>3. And use - as delimiter. Press OK</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1683810816737.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52731i490DCBF87EA98901/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1683810816737.png" alt="jthi_2-1683810816737.png" /></span></P> <P>4. Go to Tables/Stack</P> <P>5. Add your new columns to Stack Columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_3-1683810864243.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52732i6E57376998D6FDAD/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_3-1683810864243.png" alt="jthi_3-1683810864243.png" /></span></P> <P>6. Try which settings fit best for your case and press OK</P> <P>7. From your new table, select one empty value (if there are any) from your newly created data columns and choose Select Matching Cells</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_4-1683810923897.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52733i5F4545743391CD65/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_4-1683810923897.png" alt="jthi_4-1683810923897.png" /></span></P> <P>8. Right click on row selector and delete rows</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_5-1683810942915.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52734i0EB80FE54D08613F/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_5-1683810942915.png" alt="jthi_5-1683810942915.png" /></span></P> <P>9. Delete and rename columns from your table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_6-1683810968419.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52735i5BC2A264D9450DE6/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_6-1683810968419.png" alt="jthi_6-1683810968419.png" /></span></P> <P>&nbsp;</P> Thu, 11 May 2023 13:16:58 GMT jthi 2023-05-11T13:16:58Z https://community.jmp.com/t5/Discussions/dupliquer-les-cellules/m-p/630996#M82924 <P><BR /><FONT>Bonjour à tous,</FONT></P><P>&nbsp;</P><DIV>Comment dupliquer des lignes en fonction de la valeur dans les cellules.</DIV><DIV>Plus facile à comprendre avec cet exemple :</DIV><DIV>&nbsp;</DIV><DIV>Au départ :</DIV><DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hcarr01_0-1683807216180.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52726iDE674357FFAD0139/image-size/medium?v=v2&amp;px=400" role="button" title="hcarr01_0-1683807216180.png" alt="hcarr01_0-1683807216180.png" /></span><P>A la fin :</P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hcarr01_1-1683807257731.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52727i3B0A735A91DFDF50/image-size/medium?v=v2&amp;px=400" role="button" title="hcarr01_1-1683807257731.png" alt="hcarr01_1-1683807257731.png" /></span><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV> Thu, 11 May 2023 12:14:25 GMT https://community.jmp.com/t5/Discussions/dupliquer-les-cellules/m-p/630996#M82924 hcarr01 2023-05-11T12:14:25Z https://community.jmp.com/t5/Discussions/dupliquer-les-cellules/m-p/631032#M82926 <P>This should work, but I'm not 100% sure in all the cases</P> <P>Starting table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1683810765715.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52729i0ABD6B34B28EDD0C/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1683810765715.png" alt="jthi_0-1683810765715.png" /></span></P> <P>1. Select the column that has values you want to separate</P> <P>2. With the column selected go to Cols/Utilities/Text to Columns...</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1683810795895.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52730i8DBE3B783D07C67A/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1683810795895.png" alt="jthi_1-1683810795895.png" /></span></P> <P>3. And use - as delimiter. Press OK</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1683810816737.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52731i490DCBF87EA98901/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1683810816737.png" alt="jthi_2-1683810816737.png" /></span></P> <P>4. Go to Tables/Stack</P> <P>5. Add your new columns to Stack Columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_3-1683810864243.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52732i6E57376998D6FDAD/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_3-1683810864243.png" alt="jthi_3-1683810864243.png" /></span></P> <P>6. Try which settings fit best for your case and press OK</P> <P>7. From your new table, select one empty value (if there are any) from your newly created data columns and choose Select Matching Cells</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_4-1683810923897.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52733i5F4545743391CD65/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_4-1683810923897.png" alt="jthi_4-1683810923897.png" /></span></P> <P>8. Right click on row selector and delete rows</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_5-1683810942915.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52734i0EB80FE54D08613F/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_5-1683810942915.png" alt="jthi_5-1683810942915.png" /></span></P> <P>9. Delete and rename columns from your table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_6-1683810968419.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/52735i5BC2A264D9450DE6/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_6-1683810968419.png" alt="jthi_6-1683810968419.png" /></span></P> <P>&nbsp;</P> Thu, 11 May 2023 13:16:58 GMT https://community.jmp.com/t5/Discussions/dupliquer-les-cellules/m-p/631032#M82926 jthi 2023-05-11T13:16:58Z