Results 1 to 5 of 5

Copy, paste, transpose 4 cells delete and repeat

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    portland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copy, paste, transpose 4 cells delete and repeat

    I have a number of addresses in a single column (column A)
    They are in this format:

    Business Name
    Addresss
    City, State, Zip
    (555)555-5555

    There are a few thousand like that. What I need to do is to be able to copy it, past special and transpose it into the next available row. Then I want to delete those original four cells, and repeat.
    Another way to describe what I am trying to do:
    Make cells a1-a4 end up in b1- e1. Delete the contents of a1-a4 and have the next cells shift up into a1-a4. Copy, paste, transpose into b2-e2. Repeat.

    I have had limited success recording a macro for this. Basically, it just copies into b1-e1, but then the next record is copied on top of it.

    Any ideas?
    I can provide anything necessary to make this work.

    (I attached a spreadsheet to show what I'm looking to accomplish. Just make those cells transpose and end up in a row).
    Attached Files Attached Files
    Last edited by blarsen; 07-18-2012 at 12:11 AM. Reason: add attachement

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1