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!