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!