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!

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!

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!

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.

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.