conver(transpose)t datafrom rows into to coloumn

Data of one contact record is in six rows. I want to convert this data to six columns .Expected result is shown in yellow color in attached sample file.
(I have .vcf file exported from mobile. I tried to use .vcf to excel convertor but data written regional language is not converted so I have
opened .vcf file in notepad and copy it to excel)

Please help.