in B1, enter =A2

copy B1:B3

Paste down to the bottom.

"Mary Lou" wrote:

I have a spreadsheet that shows the following

column A Column B
Client Name Amount
Street Address
City State Zip

There are hundreds of clients on the spreadsheet formatted in this way.

If i add columns B, C, D and E how can i move the street name from column A
row 2 to column B row 1. Is there any way?