+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Can't transpose multiple horizontal rows of data to a vertical list

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Temecula, California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Can't transpose multiple horizontal rows of data to a vertical list

    Hello,

    I hope there is someone out there that can help me with this issue I'm having.... so here is my problem:

    I work for an internet marketing company and I need to be able to take a list of customers and their keywords that display horizontal in multiple columns and transpose that information into 2 vertical columns. I have attached a file with two tabs; one showing how the data comes out of the database and the other showing how I need the data to appear.

    For example this is how my data looks directly from the database:

    Customer ID Keyphrase 1 Keyphrase 2 Keyphrase 3 Keyphrase 4 Keyphrase 5
    96613 Pet services Groomer Dog sitter cat sitter pet grooming
    96614 plumber plumbing HVAC leaky sink plumbing repairs


    This is how I need the data:

    96613 Pet services
    96613 Groomer
    96613 Dog sitter
    96613 cat sitter
    96613 pet grooming
    96614 plumber
    96614 plumbing
    96614 HVAC
    96614 leaky sink
    96614 plumbing repairs

    I'm hoping that someone can help me out with a formula that I can use to take thousands of customers and their keyphrases and transpose the data into 2 vertical columns.......

    Thank you so much!!!
    Attached Files Attached Files
    Last edited by rschopper; 06-06-2012 at 05:40 PM. Reason: change title

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Can't transpose multiple horizontal rows of data to a vertical list

    'ROWS TO COLUMNS
    Here's a macro for expanding rows of data to multiple rows parsing out the values in the row while duplicating the header row as categories. There's a sample workbook too you could drop your data into and test it out.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    01-27-2011
    Location
    Temecula, California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Can't transpose multiple horizontal rows of data to a vertical list

    Quote Originally Posted by JBeaucaire View Post
    'ROWS TO COLUMNS
    Here's a macro for expanding rows of data to multiple rows parsing out the values in the row while duplicating the header row as categories. There's a sample workbook too you could drop your data into and test it out.
    Thank you so much Jerry!! It worked perfectly!!!

+ Reply to Thread

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