How to export multiple rows into one cell in Excel?

Remco1 — Wed, 20 Jul 2016 10:17:25 GMT

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

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

Anonymous — Thu, 21 Jul 2016 03:52:56 GMT

Hi,
Are you looking for excel "Merge Cell" function in talend?
Best regards
Sabrina

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

How to export multiple rows into one cell in Excel?

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