convert row to columns for multiple rows
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
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 ?
|