+ Reply to Thread
Results 1 to 8 of 8

Need Macro to move multiple rows into a single row for each 'Record ID'

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Need Macro to move multiple rows into a single row for each 'Record ID'

    __________
    Last edited by jonathanseah.87; 10-09-2012 at 04:18 PM. Reason: Confidentiality

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    can you show what the data looks like before? I guess my question is, does the Record ID in all the rows repeat or are they blank in between IDs?
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    Im sorry disregaurd I didnt see 2 files but I do now.

  4. #4
    Registered User
    Join Date
    10-05-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    Thanks Mike, no problem.. i know it's kind of a tedious task

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    Give this a try

    Please Login or Register  to view this content.
    Last edited by mike7952; 10-05-2012 at 08:06 AM.

  6. #6
    Registered User
    Join Date
    10-05-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    ___________
    Last edited by jonathanseah.87; 10-09-2012 at 04:19 PM.

  7. #7
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    This should work

    Please Login or Register  to view this content.
    Last edited by mike7952; 10-05-2012 at 12:41 PM.

  8. #8
    Registered User
    Join Date
    10-05-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need Macro to move multiple rows into a single row for each 'Record ID'

    __________
    Last edited by jonathanseah.87; 10-09-2012 at 04:19 PM.

+ 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