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 ? |
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 ? |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com