Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
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.