Table Manipulation

Question

Hello , i m looking to transforme my data in the last colume like this exemple :

E22SWEET 602022-02-022022-02-232022-03-1530E22SWEET60  2022-03-092022-04-19 2022-04-19 31E22SWEET60  2022-03-092022-04-19 2022-04-19 35,48

to this

E22SWEET 602022-02-022022-02-232022-03-1530E22SWEET60  2022-03-092022-04-19 2022-04-19 31E22SWEET60  2022-03-092022-04-19 2022-04-19 48E22SWEET60  2022-03-092022-04-19 2022-04-19 35

i Hope you understand what i want to do exactly ;

Thnx for your Help

JosephSerpis · Accepted Answer

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.