Hi all I have an excel with the following column values
<tbody>
</tbody>
What I need is a macro that will match all the duplicates and give me a result as follows in the next cell
<tbody>
</tbody>
ABC | XYZ |
ABC | MNO |
ABC | PQR |
WER | VRT |
WER | HYT |
WER | HIJ |
<tbody>
</tbody>
What I need is a macro that will match all the duplicates and give me a result as follows in the next cell
ABC | XYZ | ABC-XYZ,MNO,PQR |
ABC | MNO | |
ABC | PQR | |
WER | VRT | WER-VRT,HYT,HIJ |
WER | HYT | |
WER | HIJ |
<tbody>
</tbody>