Moving info from rows to columns

  • Thread starter Thread starter Mary Lou
  • Start date Start date
M

Mary Lou

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 special>values and sort to remove blanks....

If this post helps click Yes
 
Back
Top