So this isn't your everyday conditional formatting, and that's why I need some help.

I have columns of data, and some of the data has a relationship with more than one value.

http://img246.imageshack.us/i/resultwanted.png/

I want to move data from the street column to a new column next to it so that you would have a result like this:


http://img51.imageshack.us/i/datab.png/
The problem, as you may see, is that there are sometimes multiple streets, and sometimes there aren't. The trigger would obviously be that there is no data located in the name cells, so we would know that there is an extra street address to be moved to a new column.



Thanks for any help at all! I really appreciate it!