How can I change like this?
Hello:
I have the excel data like the following format. Host Category ItemName ItemValue1 OAP004 System Overview Domain Name DOMAIN1 OAP004 System Overview Operating System Microsoft(R) Windows 2003 Standard Edition OAP004 Network TCP/IP IP Address 192.168.11.26 May I know how can I change it like this? Host Domain Name Operating System IP Address OAP004 DOMAIN1 Microsoft(R) Windows 2003 Standard Edition 192.168.11.26 Thanks a lot! |
How can I change like this?
I don't think that it pasted very well... which column is "Standard Edition"
in? Also, you might want to include the next entry/data set so we get an idea of how it's layed out. -- -SA "Blue Fish" wrote: Hello: I have the excel data like the following format. Host Category ItemName ItemValue1 OAP004 System Overview Domain Name DOMAIN1 OAP004 System Overview Operating System Microsoft(R) Windows 2003 Standard Edition OAP004 Network TCP/IP IP Address 192.168.11.26 May I know how can I change it like this? Host Domain Name Operating System IP Address OAP004 DOMAIN1 Microsoft(R) Windows 2003 Standard Edition 192.168.11.26 Thanks a lot! |
How can I change like this?
Sorry for the format not clear. Below is the new one.
Befo Host Category ItemName ItemValue1 OAP004 System Overview Domain Name DOMAIN1 OAP004 System Overview Operating System Microsoft(R) Windows 200 Standard Edition OAP004 Network TCP/IP IP Address 192.168.11.26 After: Host Domain Name IP Address Operating System OAP004 DOMAIN1 192.168.11.26 Microsoft(R) Windows 200 Standard Edition Thanks a lot! |
How can I change like this?
Try this. If the first database is in A:D, and the 2nd is in F:I....
{=INDEX($A$2:$D$6,MATCH(1,($A$2:$A$6=$F2)*($C$2:$C $6=G$1),0),4)} This can be copied to G2:I100 or however far you need. I assumed you would enter the Host yourself in Column F. It is an array, so must be entered with CTRL-SHIFT-ENTER. |
How can I change like this?
Hello:
I am sorry to say that I have try but I didn't understand how to make it successful. I have attached the sample sheet. The original data was in Sheet-A and already define the name as "Master". May I know how can I make it work on Sheet-B? Thanks! Spiky wrote: Try this. If the first database is in A:D, and the 2nd is in F:I.... {=INDEX($A$2:$D$6,MATCH(1,($A$2:$A$6=$F2)*($C$2:$C $6=G$1),0),4)} This can be copied to G2:I100 or however far you need. I assumed you would enter the Host yourself in Column F. It is an array, so must be entered with CTRL-SHIFT-ENTER. |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com