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!