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!