cleaning up a database, moving variable rows into columns

[DaveAsheville]

Hi,
I have a large spreadsheet that I pasted from a website. There is a column of names (column A) that is associated with a column of street addresses (column B). For some reason the addresses appear as rows of data.

For example A2 is John Doe, A3 is blank, A4 is blank, B2 is 15 South Street, B3 is Boston, B4 is Massachusetts.

Some addresses are listed as 3 rows of data (as in the example), other addresses are 4 rows of data, and there is no consistency as to whether it is 3 or 4 rows.

How do I combine the addresses (B2,B3,B4) into the same column, given the variable length of rows?

thanks,
Dave

 

[igold]

Hi Dave,

I am not so sure that you want to combine the columns. If you have a database of addresses it is usually more desirable to have the address broken out by columns. A well planned database of addresses would normally have columns such as Name, Street Address1, Street Address2, City, State, Zip all in separate columns.

igold