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

Address Format changed after Migration 0
Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Dealing with a Pivot Table (when I don't want to) 0
Format column widths from one table to a separate table on same page 1
Transpose multiple Columns to rows 8
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Match Account ID from combining street names and numbers 1

Top