• Krtyknm (8/6/2012)


    Hey,

    Can you please provide some on idea on group the common word?

    Example:

    Code Desc

    A1 AAAA BBBB CCCC

    A1.1 AAAA BBBB CCCC DDDDD

    A1.2 AAAA BBBB CCCC DDDDD EEEEE

    A2 XXXX

    A2.1 XXXX YYYY

    A2.3 XXXX YYYY ZZZZ

    Output will be

    Code Desc Desc2 Desc3 Desc4

    A1 AAAA BBBB CCCC AAAA BBBB CCCC

    A1.1 AAAA BBBB CCCC DDDDD AAAA BBBB CCCC DDDDD

    A1.2 AAAA BBBB CCCC DDDDD EEEEE AAAA BBBB CCCC DDDDD EEEEE

    A2 XXXX XXXX

    A2.1 XXXX YYYY XXXX YYYY

    A2.3 XXXX YYYY ZZZZ XXXX YYYY ZZZZ

    Thanks,

    Karthik

    Your input and output seem to contain random numbers of columns. Please provide sample data and results in a more consumable format, as per the link in my signature.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.