Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 23 October 2017
  1 Replies
  2.7K Visits
0
Votes
Undo
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.


excel.png
  • Page :
  • 1
There are no replies made for this post yet.