Results 1 to 6 of 6

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

Threaded View

  1. 11-22-2012, 06:33 AM #1
    PeS
    PeS is offline
    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1