Table Manipulation

[Ayari]

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

[JosephSerpis · Accepted 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.