Excel 2007 : combining multiple cells of text

I have a list of data that has addresses in one cell or another. My goal is to gather the data in the non blank cell and take it to another cell on a different tab but same worksheet. Can you assist me with a formula that will do this. Here is a sample of what the data in columns W and X look like.


W x
Address 1 A Address 1 Z
1135 YELLOWSTONE AVE
35 WILDCAT WAY
440 FALLS AVE
611 WILSON AVE
150 SHOUP AVE
1910 NORTHWEST BLVD

The tab the data is on is called "Paste Data here" and the formula is on tab "Monthly Doc"