Hello,

First post: urgent question.

Data looks like this:

Joe, Bob
Madison, Billy
Drew, Larry

Ying, Min
Yong, Mong

Ting, Tong
John, Jacob


Not only do I need to develop a macro to transpose each of these sets (separated by spaces) into columns, but also I need to then combine them into one cell separated by a space.

The key here: to develop a code to concatenate everything into the first cell, but just run it once so that it will know to group together only the ones separated by spaces all the way down to yield the following

Joe, Bob , Madison, Billy , Drew, Larry

Ying, Min , Yong, Mong

Ting, Tong , John, Jacob