dupliquer les cellules

[#1]

Bonjour à tous,

Comment dupliquer des lignes en fonction de la valeur dans les cellules.

Plus facile à comprendre avec cet exemple :

Au départ :

hcarr01_0-1683807216180.png

A la fin :

hcarr01_1-1683807257731.png

[#2 · Accepted solution]

This should work, but I'm not 100% sure in all the cases

Starting table

jthi_0-1683810765715.png

1. Select the column that has values you want to separate

2. With the column selected go to Cols/Utilities/Text to Columns...

jthi_1-1683810795895.png

3. And use - as delimiter. Press OK

jthi_2-1683810816737.png

4. Go to Tables/Stack

5. Add your new columns to Stack Columns

jthi_3-1683810864243.png

6. Try which settings fit best for your case and press OK

7. From your new table, select one empty value (if there are any) from your newly created data columns and choose Select Matching Cells

jthi_4-1683810923897.png

8. Right click on row selector and delete rows

jthi_5-1683810942915.png

9. Delete and rename columns from your table

jthi_6-1683810968419.png