Transfer data across rows to columns

[YasserKhalil]

Hello everybody
I have in sheet("Data") a range of data starting in H2 ..
I simply need to make the data which are across rows to be in two columns as illustrated in the attachment
I prefer using arrays

Thanks advanced

[PCI]

Try next code
It assumes there is no duplicate

Please Login or Register  to view this content.

[YasserKhalil]

It assumes there is no duplicate

What do you mean by that ?
in original file there are some duplicates ..

[HSV]

Is this what you are looking for Yasser?

Please Login or Register  to view this content.

[YasserKhalil]

Mr. PCI
Mr. HSV

Thanks a lot for this great help
You're awesome people
Thank you very much for these magic codes