+ Reply to Thread
Results 1 to 7 of 7

Need help combining multiple rows and columns of data on a large document

  1. #1
    Registered User
    Join Date
    12-22-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Need help combining multiple rows and columns of data on a large document

    Hello!


    I am currently working on a document, which has 5500 rows of data, which has anywhere from 2-5 rows of duplicates of the same user. Although the row may be for the same user, each row has different data which needs to be combined in the same column and not lost. I've been trying to find some basic VBA code online, but I can't find any that works.

    Sample is attached. Ideally, I'd like to have all of John's data in one row, and all of Sally's data in one row.


    Many thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-31-2010
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    149

    Re: Need help combining multiple rows and columns of data on a large document

    Sorry I don't understand what your doing, so if say all of johns data is on the same row, does that mean there would only be one date value 1 and so on.

  3. #3
    Registered User
    Join Date
    12-22-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need help combining multiple rows and columns of data on a large document

    Hi! So John has 4-5 rows, each with partial data (i.e. one row has the data in column b, one row has the data in column e). I would like to take all the data in the 4-5 rows, and combine them into one row.

  4. #4
    Registered User
    Join Date
    12-22-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need help combining multiple rows and columns of data on a large document

    If it makes it easier, see the attached document. The "Ideal data" tab in the doc is what I'm trying to accomplish, from the "Raw data" tab. Thanks!
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-22-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need help combining multiple rows and columns of data on a large document

    Also, there will only ever be one value in each column per person -- we just need to take all five rows, and merge them into one row. There will only be one value in each set of column cells that need to be merged. Hope that makes sense!

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: Need help combining multiple rows and columns of data on a large document

    Try the attached
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    12-22-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need help combining multiple rows and columns of data on a large document

    Thank you, that works!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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