conver(transpose)t datafrom rows into to coloumn

[kv.singh]

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.

[ardross]

It is a bit of a mystery where Version 2.1, 2.2, 2.3 came from as they are not in your source data!!

In B1, copied across and down:

=IFERROR(INDEX($A$1:$A$18,6*(ROWS(B$1:B1)-1)+COLUMNS($B1:B1),),"")

[kv.singh]

Thanks.
I have 80000 records in col.A please suggest what change I have to do in formula.

[JEC.]

With that amount of data you should use a macro or power query, instead of a formula

Edit: I think I transposed it the other way around

Please Login or Register  to view this content.

[JEC.]

This is the other way around

Please Login or Register  to view this content.

[ardross]

Who are you talking to?

If me...


=IFERROR(INDEX($A$1:$A$80000,6*(ROWS(B$1:B1)-1)+COLUMNS($B1:B1),),"")

[AliGW]

Obviously you, since the question came before the contributions of the other contributor and immediately after your first post!