convert row to columns for multiple rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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
 
Back
Top