How to export multiple rows into one cell in Excel?

Six Stars

How to export multiple rows into one cell in Excel?

I've the following (two columns, three rows):
column1 column2
1234      test1
5678      test2
9135      test3
I've to export this into excel (two columns, one cell) :
column1              column2
1234                   test1 
5678                   test2
9135                   test3
It looks the same however in excel the data is put into one cell, data is put on a new line bij ALT+Enter (see attachement).

How to achieve this?
Thnx Remco
Moderator

Re: How to export multiple rows into one cell in Excel?

Hi,
Are you looking for excel "Merge Cell" function in talend?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.