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:

ENG	KU
book	pirtûk
table	mase
tree	dar

<colgroup><col><col></colgroup><tbody>
</tbody>

my kurdish-Persian data as below:

KUR	PERS
dar	dirext
sar	serd
pirtûk	ketab
mase	miz
zêr	zer
mêr	merd

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

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

ENG	KU	KU	PERS
book	pirtûk	dar	dirext
table	mase	sar	serd
tree	dar	pirtûk	ketab
		mase	miz
		zêr	zer
		mêr	merd

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

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

ENG	KU	KU	PERS
book	pirtûk	pirtûk	ketab
table	mase	mase	miz
tree	dar	dar	dirext

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

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.