Moving info from rows to columns

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

Jacob Skaria

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
Upper to Lowercase in Excel 7
Excel Subtracting multiple columns from another column 3
another text to column problem 11
Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D 2
Counting multiple criteria across columns and rows??? 1
Rows to Columns 1

Top