I see many threads discussing how to take contents of various cells and
concatenate into a single cell on separate lines (= A1 & char(10) & A2 &
char(10) & A3 ....., etc.). How do I do the inverse process? In other
words, how do I take a single cell consisting of multiple entries (each on a
seperate line) and copy it to multiple cells so that each of these new cells
has only one distinct entry?

This question is in the context of an imported databse. Some of the columns
only have one entry per record, while others have more than 1 entry per
record. I want to split these multi-entry records into separate records.
The database is too large to do manually...
--
Regards, timg.

If you wanted to separate that data into more fields on the same row (just using
more columns), you could use:

Select the column
data|Text to columns
Delimited
in the other box, hit ctrl-j (same as char(10))
and finish up.



timg wrote:

I see many threads discussing how to take contents of various cells and
concatenate into a single cell on separate lines (= A1 & char(10) & A2 &
char(10) & A3 ....., etc.). How do I do the inverse process? In other
words, how do I take a single cell consisting of multiple entries (each on a
seperate line) and copy it to multiple cells so that each of these new cells
has only one distinct entry?

This question is in the context of an imported databse. Some of the columns
only have one entry per record, while others have more than 1 entry per
record. I want to split these multi-entry records into separate records.
The database is too large to do manually...
--
Regards, timg.

--

Dave Peterson

Dave,

Thank you. You've helped me on my way ...
--
Regards, timg.


"Dave Peterson" wrote:

If you wanted to separate that data into more fields on the same row (just using
more columns), you could use:

Select the column
data|Text to columns
Delimited
in the other box, hit ctrl-j (same as char(10))
and finish up.



timg wrote:

I see many threads discussing how to take contents of various cells and
concatenate into a single cell on separate lines (= A1 & char(10) & A2 &
char(10) & A3 ....., etc.). How do I do the inverse process? In other
words, how do I take a single cell consisting of multiple entries (each on a
seperate line) and copy it to multiple cells so that each of these new cells
has only one distinct entry?

This question is in the context of an imported databse. Some of the columns
only have one entry per record, while others have more than 1 entry per
record. I want to split these multi-entry records into separate records.
The database is too large to do manually...
--
Regards, timg.

--

Dave Peterson