Hi,
The data has been clubbed on posting the message.
It should be something liek this:

Original List:
A B
In the diamond In the diamond
In the diamond The City
In the diamond Trench
The City
The City
Trench


Result :

A B
In the diamond In the diamond
In the diamond
In the diamond
The City The City
The City
Trench Trench

Is it possible to arrange the data as shown in the Result list:

Iam wondering if this logic will work, but not sure to write the code and
would appreciate if someone could help

If B=A
B=B (remain the data in B)
Else
Lookup (lookup for that item)
Match (I think only match is fine; it looks for the item returns the
row number)
Next place it in that row, same column B
If no match found: Place it in column B, but last row of A where the item
list is over