+ Reply to Thread
Results 1 to 6 of 6

Consolidate data in 2 rows into 1 row, based on column criteria

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Prague
    MS-Off Ver
    Excel 2007
    Posts
    3

    Consolidate data in 2 rows into 1 row, based on column criteria

    Hi
    I'm bit stuck with this

    Contrato Denominación Valor caract.
    10584966 Landing door T2
    10584966 Door opening direction TELESCOPIC LEFT
    10584968 Landing door T2
    10584968 Door opening direction TELESCOPIC RIGHT



    I would like to consolidate as
    Contrato Landing door Door opening direction
    10584966 T2 TELESCOPIC LEFT
    10584968 T2 TELESCOPIC RIGHT



    Any idea how to automatize? I have 20,000 lines...

    Many thanks

    PeS
    Last edited by PeS; 11-23-2012 at 04:36 AM.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Consolidate data in 2 rows into 1 row, based on column criteria

    Please attach a workbook sample with a desired result

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    Prague
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Consolidate data in 2 rows into 1 row, based on column criteria

    Here it is

    Thanks a lot

    PeS
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Consolidate data in 2 rows into 1 row, based on column criteria

    hi PeS, welcome to Excelforum, please check attachment, option to make it, press Run button or run code "test"

    PS. The code does sorting. If the data comes sorted, delete this line:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by watersev; 11-22-2012 at 10:40 AM.

  5. #5
    Registered User
    Join Date
    11-14-2012
    Location
    Prague
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Consolidate data in 2 rows into 1 row, based on column criteria

    Works very well, Dyakooyu!

  6. #6
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Consolidate data in 2 rows into 1 row, based on column criteria

    prosim ......

+ 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