for example i have the excel sheet1 like this

name : sara
tele : 111111
fax:ooooooo

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 ?