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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match Account ID from combining street names and numbers 1
Transpose multiple Columns to rows 8
Need VLOOKUP to Work Two Ways 0
Excel Help to copy information from one row at a time to another sheet 1
moving part of a column into another column 3
Upper to Lowercase in Excel 7
combining column content 8
Excel Subtracting multiple columns from another column 3

Back
Top