for example i have the excel sheet1 like this

name : sara
tele : 111111
faxoooooo

name :george
tele :444444
fax:99999999

i want to them to appear like this:
name tele fax
sara 11111 00000
george 44444 99999999

i tried copy and pase special choosing transpode , but it works only for one
record and i have to copy and pase evry record .

i have 500 names , so how can i do it ?

try:

Your data in A &B, starting row 1, with pattern of 3 records followed by
blank row

In C1-E1 put "name","tele", "fax"

in c2:

=VLOOKUP(C$1,INDIRECT("$A" &(ROW()-2)*4+1 & ":$B$3000"),2,0)

Copy across to E2

Copy down until you get #N/A

HTH
"Heba" wrote:

> for example i have the excel sheet1 like this
>
> name : sara
> tele : 111111
> faxoooooo
>
> name :george
> tele :444444
> fax:99999999
>
> i want to them to appear like this:
> name tele fax
> sara 11111 00000
> george 44444 99999999
>
> i tried copy and pase special choosing transpode , but it works only for one
> record and i have to copy and pase evry record .
>
> i have 500 names , so how can i do it ?
>