Create multiple row with carriage return cell value in excel

[Parikhharshal]

Hi Talend experts

Could you please help me with this unique problem of reading data from excel and streamlining it to make it readable?

I have got data in excel like this having carriage return as a searator to add new value to cell:

student_cours Unit

123_mktg 2020 abc (90) PASS

2020 xyz (Enr)

2020 efg (Enr)

2020 erp (Enr)

I want to make it like this:

123_mktg       2020 abc (90) PASS

123_mktg      2020 xyz (Enr)

123_mktg      2020 erp (Enr)

How can I do it from excel?

Thanks

Harshal.

[Anonymous]

Hi

Can you attach an example Excel file? I want to see what's the output if I use tFileInputExcel component to extract the data.

Regards

Shong