Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Remco1
Contributor III
Contributor III

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
Labels (2)
1 Reply
Anonymous
Not applicable

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