+ Reply to Thread
Results 1 to 7 of 7

Covert Vertical Data to Horizontal with multiple values assigned to each unique ID

  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    Miami, US
    MS-Off Ver
    Excel 2007
    Posts
    83

    Covert Vertical Data to Horizontal with multiple values assigned to each unique ID

    Hello,

    I have excel spread sheet with each individual (Client_ID) attending a program on different dates. It is in the form of vertical data. I am trying to make it horizontal. My problem is each client_ID is linked to two programs in this case. So when I try to convert vertical data into horizontal it takes its uppermost event name and does not consider the second one.

    Attached please find the sample of what I am trying to do. All the data is in vertical form (left three columns). On upper right side, please see what I have done so far. Below (highlighted in pink) is the way I need it.

    Thank you so much for the help.
    Ajang

    Sorry, I forgot to attach the file before.

    Thank you Pike
    Attached Files Attached Files
    Last edited by ajang; 11-19-2011 at 02:51 PM.

  2. #2
    Registered User
    Join Date
    10-13-2010
    Location
    Miami, US
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Covert Vertical Data to Horizontal with multiple values assigned to each unique I

    Hi,

    Just a gentle reminder. Can someone please help me with the above problem?

    Thanks

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Covert Vertical Data to Horizontal with multiple values assigned to each unique I

    cant see what you are doing as all the data looks the same
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    10-13-2010
    Location
    Miami, US
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Covert Vertical Data to Horizontal with multiple values assigned to each unique I

    Hello,

    I have an Excel spreadsheet with each individual (Client_ID) attending a program (or multiple programs) on different dates. The data is presented verticallym, but I need ti to be horizontal. My problem is each client_ID is linked to two programs in this case. So when I try to convert the vertical data into horizontal by using vlookup, it takes the first event name and does not consider the second one.

    Attached please find the sample of what I am trying to do. All the data is in vertical form (left three columns). On upper right side, please see what I have done so far. Below (highlighted in pink) is the way I need it.

    Thank you so much for the help.
    Ajang
    Attached Files Attached Files
    Last edited by ajang; 11-19-2011 at 02:51 PM.

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Covert Vertical Data to Horizontal with multiple values assigned to each unique I

    struggled here but this works maybe some other way?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-13-2010
    Location
    Miami, US
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Covert Vertical Data to Horizontal with multiple values assigned to each unique I

    Hi Martin,

    In the spreadsheet, I see taht we get the event name but I cannot get all the dates. I need all the dates to go with the event name; both for event 1 and event 2. I just aded one column after event name in the sample just to give an example. However in actual file, I need all the dates for each participant by their event.

    Thanks
    Last edited by ajang; 11-20-2011 at 12:17 AM. Reason: Wrong post

  7. #7
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Covert Vertical Data to Horizontal with multiple values assigned to each unique I

    this is what happens when you don't give your full requirements from the start,i think you'll have to use some vba code as the entries per client vary

+ 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