Sorry for the information not enought. Yes, it will have another
hostname. The hostname in Sheet-B is Manual copy. For the Hostname in
Sheet-A, it will have more than 3 rows. The order of Sheet-A will not
have the same order but the Hostname I will sort in order.

Thanks!

Rick Rothstein (MVP - VB) wrote:
I think a little bit more information would be helpful. Will there be
other Host names on Sheet-A (with their own unique information)? How
is the Host name getting into Sheet-B... are you typing it and wanting
the other information looked up or, if there will be more than one
Host, are you wanting all the Host names populated on Sheet-B
automatically? For a single Host name, will there **always** be three
rows of information on Sheet-A? Will the rows of information on
Sheet-A **always** be in the same order (for each Host)?

Rick


"Blue Fish" wrote in
message ...
Hello:

I have the problem how to re-format the data. 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?

Sheet-A Original Data:
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


Sheet-B Re-format Data:
Host
Domain Name
Operating System
IP Address
OAP004
DOMAIN1
Microsoft(R) Windows 200 Standard Edition
192.168.11.26



The First row is the header.

Thanks a lot!