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?

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?

Insert columns so that amount is in ColE and in cell B1 enter the below
formula.
Copy across to cols C,D..Now copy the formula down as required....

=IF($E1<"",OFFSET($A1,COLUMN(A1),0),"")

Once done copy paste specialvalues and sort to remove blanks....

If this post helps click Yes
---------------
Jacob Skaria


"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?