Pleae help me for consolidate data's

[sampath]

Hello,

I have list of data and i need to consolidate the particular data from that list.

Could you help me if any macros or formula. I have given the samples below.

Input is
132 RN1215-MN- RN1215-SE-
55-RN 158

Output
RN1215-MN-55-RN RN1215-SE-158


Please assist me which is very helpful for our project.

Thank with regards,
Sampath.S

 

[Sathish KV]

Hi,

Could you upload a file with 2 to 3 sample data