1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel 2007 Move Data to Another Cell

Discussion in 'Business Applications' started by BettyAtKitchen, Aug 5, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. BettyAtKitchen

    BettyAtKitchen Thread Starter

    Joined:
    Apr 22, 2008
    Messages:
    116
    I work with Excel 2007. If under column A, I have 900 names of Restaurants, and under each name of restaurant, is a one-line address of the restaurant, what should be done so that the address can be moved to the cell to the right of the restaurant.

    For example

    This is the original data:

    Column A
    AAA Restaurant
    AAA address
    BBB Restaurant
    BBB address
    CCC Restaurant
    CCC address


    This is the desired result

    Column A Column B
    AAA Restaurant AAA address
    BBB Restaurant BBB address
    CCC Restaurant CCC address

    Thanks is advance
     
  2. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    I am sure it can be done with VBA, but there is a really handy free tool for Excel called ASAP Utilities ( http://www.asap-utilities.com/ ) which is a collection of VBA tasks. One of them is called Advanced Transposer, which can change the data from one column to however many you want - in this case 4.
     
  3. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    If you're in a situation where you can't install add-ins, enter this formula in B1:

    =INDIRECT("A"&ROW()*2-(COLUMN()-1))

    and copy it to B2:B450.

    Then enter this formula in C1:

    =INDIRECT("A"&MATCH(B1,A:A,0)+1

    and copy it to C2:C450.

    Select columns B:C and Copy > Edit > Paste Special > Values.

    Then you can delete the original data.
     
  4. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Good one Bomb. I do love ASAP, but nice to have other ways to do stuff!
     
  5. BettyAtKitchen

    BettyAtKitchen Thread Starter

    Joined:
    Apr 22, 2008
    Messages:
    116
    Thanks for all the advice. This is now officially marked "Happily Solved"
     
  6. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Good!!!
    :D
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/737176

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice