Results 1 to 6 of 6

columnwise matching of data

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Unhappy columnwise matching of data

    i have faced lots of problem for matching the data in column and rearrange in row, please help me out,
    for example:
    CELL
    GUW0263

    CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
    0 SYSDEF 0 0 EGPRS

    ETCHTN TNBCCH
    0 1 2 3 4 5 6 7

    CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
    1 SYSDEF 20 0

    ETCHTN TNBCCH
    0 1 2 3 4 5 6 7

    END

    <RLBDP:CELL=GUW0281;
    CELL CONFIGURATION BPC DATA

    CELL
    GUW0281

    CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
    0 SYSDEF 0 0 EGPRS

    ETCHTN TNBCCH
    0 1 2 3 4 5 6 7

    CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF
    1 SYSDEF 15 0

    ETCHTN TNBCCH
    0 1 2 3 4 5 6 7

    END

    And i want the output as

    cell CHGR NUMREQBPC NUMREQEGPRSBPC NUMREQCS3CS4BPC TN7BCCH EACPREF ETCHTN TNBCCH
    GUW0263 0 SYSDEF 0 0 EGPRS 0 1 2 3 4 5 6 7
    1 SYSDEF 20 0 0 1 2 3 4 5 6 7
    GUW0281 0 SYSDEF 0 0 EGPRS 0 1 2 3 4 5 6 7
    1 SYSDEF 15 0 0 1 2 3 4 5 6 7

    Please get me some way to solve it
    Last edited by gauranga_25102010; 04-24-2012 at 04:26 AM.

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