Bonjour à tous,
Comment dupliquer des lignes en fonction de la valeur dans les cellules.
Plus facile à comprendre avec cet exemple :
Au départ :
A la fin :
1 ACCEPTED SOLUTION
Accepted Solutions
This should work, but I'm not 100% sure in all the cases
Starting table
1. Select the column that has values you want to separate
2. With the column selected go to Cols/Utilities/Text to Columns...
3. And use - as delimiter. Press OK
4. Go to Tables/Stack
5. Add your new columns to Stack Columns
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
8. Right click on row selector and delete rows
9. Delete and rename columns from your table
This should work, but I'm not 100% sure in all the cases
Starting table
1. Select the column that has values you want to separate
2. With the column selected go to Cols/Utilities/Text to Columns...
3. And use - as delimiter. Press OK
4. Go to Tables/Stack
5. Add your new columns to Stack Columns
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
8. Right click on row selector and delete rows
9. Delete and rename columns from your table