Merge multiple columns and rows as individual rows....

If I have a table like the one on the left. Notice how the rows include ones where there is no information.

The results should look like the right. The contents should be joined, and cells merged (and aligned to the left) for all the columns selected. It should then go to the next selected row and do the same and continue until either the end of the selection or there is no data in all 3 cells.

I have code to do this with a single row of multiple selected columns, but I don't know how to expand this to multiple selected rows.

Please Login or Register  to view this content.

Hi
If you insist on code
Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

alan - concatenate, isn't that a function and not VBA? Also, that doesn't merge cells or handle selections.
mohadin - got an error "We can't do that with a merged cell"?
jindon - Perfect! Does exactly what I needed - no more, no less!