Hello,
How do I go about this on excel:
Assuming I have a list of Data on Column A
Example:
ABCD123
CEFG456
RRR111
FFF222
CCCDDD
and so on..
Then on Column B1, the output will be joined and seperated by a Semi colon? So it look like this.
ABCD123;CEFG456;RRR111;FFF222;CCCDDD;
Please note that the number of records on column A will vary, at times a lot, at time a few.
Hope you could help how to make a formula for this, thanks.
Bookmarks