asddsa88
11-09-2011, 02:41 PM
Hello, I am trying to create a macro to concatenate multiple rows (200).
My rows are made of a variable number of individual cells with text inside (from 1 to 10 max).
My aim is to concatenate single cells one after the other in a single row.
Example:
dog cat wolf
owl
[blank row to be automatically skipped or eliminated]
man female
result would be:
dog cat wolf owl man female
ps:
a nice add-on feature would be:
if all the cells in a row are exactly the same and in the same sequence as cells in any other row(s), then keep just 1 row and delete duplicate row(s).
Any ideas?
Thanks in advance!
My rows are made of a variable number of individual cells with text inside (from 1 to 10 max).
My aim is to concatenate single cells one after the other in a single row.
Example:
dog cat wolf
owl
[blank row to be automatically skipped or eliminated]
man female
result would be:
dog cat wolf owl man female
ps:
a nice add-on feature would be:
if all the cells in a row are exactly the same and in the same sequence as cells in any other row(s), then keep just 1 row and delete duplicate row(s).
Any ideas?
Thanks in advance!