merging two data file with same rows in a new columns for new dictionary (macro)

[osmanoca]

Hello dear helpfull mrexcel friends..i need help please. very important .thanks

i have two excel file for dictionary. Both are for two languages . both are with columns. word and meaning. but one language of two dictionaries is same. for example i have English-kurdish and kurdis-persian files. i want make make persian english new dictionary with same rows in kurdish. i pasted their columns side to side as: Eng-Kur is column A and B , Kurdish-Persian column is C and D so i want merging or bringing same rows in kurdish (column B-C) in one row.


example
my Eng-Kurdish data as below:

[TABLE="width: 245"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]ENG[/TD]
[TD]KU[/TD]
[/TR]
[TR]
[TD]book[/TD]
[TD]pirtûk[/TD]
[/TR]
[TR]
[TD]table[/TD]
[TD]mase[/TD]
[/TR]
[TR]
[TD]tree[/TD]
[TD]dar[/TD]
[/TR]
</tbody>[/TABLE]

my kurdish-Persian data as below:

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]KUR[/TD]
[TD="class: xl65, width: 64"]PERS[/TD]
[/TR]
[TR]
[TD]dar[/TD]
[TD]dirext[/TD]
[/TR]
[TR]
[TD]sar[/TD]
[TD]serd[/TD]
[/TR]
[TR]
[TD]pirtûk[/TD]
[TD]ketab[/TD]
[/TR]
[TR]
[TD]mase[/TD]
[TD]miz[/TD]
[/TR]
[TR]
[TD]zêr[/TD]
[TD]zer[/TD]
[/TR]
[TR]
[TD]mêr[/TD]
[TD]merd[/TD]
[/TR]
</tbody>[/TABLE]


i pasted two file side by side in one file as ABCD columns as below:

[TABLE="width: 373"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]ENG[/TD]
[TD]KU[/TD]
[TD]KU[/TD]
[TD]PERS[/TD]
[/TR]
[TR]
[TD]book[/TD]
[TD]pirtûk[/TD]
[TD]dar[/TD]
[TD]dirext[/TD]
[/TR]
[TR]
[TD]table[/TD]
[TD]mase[/TD]
[TD]sar[/TD]
[TD]serd[/TD]
[/TR]
[TR]
[TD]tree[/TD]
[TD]dar[/TD]
[TD]pirtûk[/TD]
[TD]ketab[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]mase[/TD]
[TD]miz[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]zêr[/TD]
[TD]zer[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]mêr[/TD]
[TD]merd[/TD]
[/TR]
</tbody>[/TABLE]

i want macro code to rearrange and bring only same rows with two columns near to eachother in new columns as below:

[TABLE="width: 373"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]ENG[/TD]
[TD]KU[/TD]
[TD]KU[/TD]
[TD]PERS[/TD]
[/TR]
[TR]
[TD]book[/TD]
[TD]pirtûk[/TD]
[TD]pirtûk[/TD]
[TD]ketab[/TD]
[/TR]
[TR]
[TD]table[/TD]
[TD]mase[/TD]
[TD]mase[/TD]
[TD]miz[/TD]
[/TR]
[TR]
[TD]tree[/TD]
[TD]dar[/TD]
[TD]dar[/TD]
[TD]dirext[/TD]
[/TR]
</tbody>[/TABLE]

then i will delete kurdish columns and make ENG-PERS dictionary

please give me a way to arrive this solution. macro please. very very thanks..

 

[Akuini]

You're welcome & thanks for replying.

---

And you can also click ‘Thank for this post’ and ‘Like this post’ button in the post that you like.