Data formating - Macros

[sampath]

Dear Friend,


I need to convert the huge data from following format.

[pre]

INPUT
A              B               C.........
1        S1             S2              S3
2        105            262             MA
3        266            107             1088
4        R262 1088      262             107
5        MAS            1062 MA         R262
6        105 MBB        756             1088 1925
7                       2065            R265 MAS

Required OUTPUT
A        B
1         S1       105-266-1088-MAS-MBB-R262
2         S2       107-262-756-1062-2065-MA
3         S3       107-1088-1925-MA-MAS-R265

[/pre]

Please anyone help me to convert from above mentioned data as macros.


Regards,

Sampath.S

 

[Hui]

Sampath


Please note that nothing is Urgent here and marking posts as such will not mean you get any faster help than anyone else.


Please read: http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


Explaining the relationship between the data as displayed before and after will ensure you get a faster more accurate response!

 

[NARAYANK991]

Hi Sampath ,


I think for S3 , the output should be :


107-1088-1925-MA-MAS-R262-R265


unless the R262 is a mistake , and should actually read R265.


Narayan

 

[sampath]

Hi NARAYAN,


Thanks for your response, sorry, That one is typo error, your statment is right(R265).


Please help me do make that format. we have huge data such kind of inputs.


Sampath

 

[NARAYANK991]

Hi Sampath ,


Will do. Give me some time.


Narayan

 

[NARAYANK991]

Hi Sampath ,


Can you check the file here ?


https://www.dropbox.com/s/hycx0rmkaw7trd4/Sampath_Example.xlsm


Narayan

 

[sampath]

Hi Narayan,


Your given document is working fine. Thanks for your support for our project.


I really excited. Thanks once again.


Regards,

Sampath.S