Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rows to Columns (2002/XP)

    I have a spreadsheet with multiple rows of data for the same person or ID#. However, every person/ID may not have the same number of Values. Some may have 3 values, others 2 and others 1 or more than 3. I need to have the result reflect one row for each person/ID with each Value in a different corresponding column. I've seen the offset function in Excel Help (although I'm not sure I understand how it works) that looks like it can accomplish this if there is a fixed number of rows for each person/ID, but I can't find a formula or series of formulas to accomplish this with differing rows. Please see the attached example and thank you in advance for your input. Also, if possible I would prefer to accomplish this without using a macro, because I will have to train others on how to do it or do it on different PC's. However, if a macro is the best or only solution, I'll take it.
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rows to Columns (2002/XP)

    Consider a pivot table.

    I have applied this approach to your example and attach the file.

    Andrew C
    Attached Files Attached Files

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Rows to Columns (2002/XP)

    Hi,
    Take a look at <post#=171444>post 171444</post#> and the related threads. They address a similar problem to the one you're trying to solve.
    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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