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