Hello , i m looking to transforme my data in the last colume like this exemple :
E22 | SWEET 60 | 2022-02-02 | 2022-02-23 | 2022-03-15 | 30 |
E22 | SWEET60 | 2022-03-09 | 2022-04-19 | 2022-04-19 | 31 |
E22 | SWEET60 | 2022-03-09 | 2022-04-19 | 2022-04-19 | 35,48 |
to this
E22 | SWEET 60 | 2022-02-02 | 2022-02-23 | 2022-03-15 | 30 |
E22 | SWEET60 | 2022-03-09 | 2022-04-19 | 2022-04-19 | 31 |
E22 | SWEET60 | 2022-03-09 | 2022-04-19 | 2022-04-19 | 48 |
E22 | SWEET60 | 2022-03-09 | 2022-04-19 | 2022-04-19 | 35 |
i Hope you understand what i want to do exactly ;
Thnx for your Help
Solved! Go to Solution.
Hi @Ayari you can use a text to column tools and set the configure to spilt to rows based on a delimeter such as a comma in your last column.