Transform Line to colum

[Judicael]

Hello,

How can I tranform tab Data to Tab RESULT in (Excel File) automatically mode with for next if it is necessary.

Data in attachment.

Thanks for your help,

Regards,

[dplr-rn · Accepted solution]

Am i right in guessing you want all the rows to be split with '[Actif]'

Use something like below while loading the data

load *
where PROFILES <>''
;
load id,
SubField(trim(PROFILES),' [Actif]')as PROFILES
;
LOAD id,
PROFILES
FROM
[C:\Users\Downloads\Data.xls]
(biff, embedded labels, table is Data$);

result

[Judicael]

Thanks you very much!!