I have data in column A that is imported from a text file. I want to copy "Like" data to different columns. For example:

Column A Column B Column C
Test1 Test1 Bent1
Bent1 Test2 Bent2
Bent2 Test3 Bent3
Test2
Test3
Bent3

Can anyone help me with the VBA code to find data that is like each other, then loop through and putting it into another column?