I can join two or more columns but is there a way to do this in alphanumeric order of the data sets. ie: Row 1 Column 1 "Twain, Mark" Column 2 " Williams, Sue" Column 3 " Brown, Ron" How do I get to " Brown, Ron, Twain, Mark, Williams, Sue" in column 4 I may have up to 5 columns and 70 rows where some cells are blank ie if column 3 is blank then 4 to 5 are blank also
Solved by E. E. in 14 mins