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.
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.
