Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert row to columns for multiple rows
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 ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Convert Multiple Rows into Multiple Columns | Excel Worksheet Functions | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Convert rows to Columns | Excel Worksheet Functions | |||
Convert rows to columns | Excel Worksheet Functions | |||
Convert multiple columns to rows | Excel Worksheet Functions |