excel data transposing

[suriya6in]

hi

I have a data in the following format with inbetween empty rows as:

---------------
name1
address1
phone1

<empty row>
<empty row>

name2
address2
phone2

<empty row>
<empty row>

name3
address3
phone3

--------------

just like a label format. now i want to make a transpose of this.
all the above data are in the first column A1.
Now it should come in a Three column format as

Name1 address1 phone1
Name2 address2 phone2
Name3 address3 phone3

how do i do this?
Any addins?

regards
suriya

[suriya6in]

hi

I've made it.!!!

First copy the entire thing in to Microsoft word as unformatted text.
Then select all and go to table menu -> Convert Text to table option and then give the number of columns we need, then click ok. then copy this to excel/.

That's it!
The only important thing we have note here is, the number of rows which has data in each group should be same.
For exampls,

name1
address1
phone1

name2
address2
phone2

as all the group has only 3 rows of data.!!!

regards
suriya