Skip to main content
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
  6.4K 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.