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.

Transposing column data into multiple columns

Discussion in 'Business Applications' started by bromano, Jun 18, 2008.

Thread Status:
Not open for further replies.
  1. bromano

    bromano Thread Starter

    Joined:
    Jun 18, 2008
    Messages:
    1
    I have a large excel file (3k= rows) of name/addr info. I want to transpose the date so information appears in its own column for sorting, etc. The problem is the data is not consistant. (sometimes there is two address enteries, sometimes three. In another record there may be two phone numbers. So each company may have six or seven rows of info. The only consistancy is that the company name is in bold. I've tried to attach a sample file so you can see what my task is. I'm not real good with Excel, so treat me like a dumy; it's OK. :)


    I really appreciate the help.

    Bill
     

    Attached Files:

  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,828
    Bill, that was an awkward one, but I think this does what you want.
    Just click on the "CommandButton1" and watch.
     

    Attached Files:

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/722519

  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