Pivot in Script?

[RenanDRN]

How i can transform this table:

Product_Name	code	Date
AAA1234	6601;6602;6603;6604	10/10/2022 00:01:49;11/10/2022 00:30:00;12/10/2022 01:23:15; 12/10/2022 02:56:02
BBB1234	6605;6606;6607;6608	12/10/2022 00:01:49;13/10/2022 00:30:00;12/10/2022 01:23:15; 12/10/2022 02:56:02

Into this:
OBS: Separated into pairs on the same line

Product_Name	code	Date	Product_Name	code	Date
AAA1234	6601	10/10/2022 00:01:49	AAA1234	6602	11/10/2022 00:30:00
AAA1234	6603	12/10/2022 01:23:15	AAA1234	6604	12/10/2022 02:56:02
BBB1234	6605	10/10/2022 00:01:49	BBB1234	6606	11/10/2022 00:30:00
BBB1234	6607	12/10/2022 01:23:15	BBB1234	6608	12/10/2022 02:56:02

[BrunPierre]

Use the subfield() function like this to split a field into multiple records.

SubField(code,';') as code
SubField(Date,';') as Date