Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

excel, merge multiple columns into a cell with multiple rows

More
1 year 5 months ago #192 by Jay Chivo
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 5 months ago #191 by zh c
hi, i currently have some data in excel that i need to sort out.

the data is in 3 columns, with almost 3000 rows of such data. i need to merge the content of 3 columns per row, into 3 rows, in a single cell. I know i can apply concatenate, with the CHAR(10) to represent linebreak. However, these are actually commands that i want to run. is it possible to extract out the info i need automatically? when i "copy" out the content of the cell, the line breaks disappear. anyone able to advise?

i have an example of what i want to achieve. The end goal is to be able to copy out the cells into a text file.


Attachments:

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo