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.