How can I change like this?

Posted to microsoft.public.excel.worksheet.functions

Blue Fish[_2_] Blue Fish[_2_] is offline

external usenet poster

Posts: 11

How can I change like this?

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change formula in a shared worksheet without losing change history	DCE	Excel Worksheet Functions	5	July 25th 08 01:37 PM
change scaling % but font size didnt change porportionally, pls he	Scaling question	Excel Discussion (Misc queries)	0	March 12th 07 03:16 AM
Excel bar chart formatting of bars to change colors as data change	JudyT	Excel Discussion (Misc queries)	1	January 24th 07 06:07 PM
Use date modified to change format & create filter to track change	PAR	Excel Worksheet Functions	0	November 15th 06 09:17 PM
Change workbook sheet reference using cell A1 to change a vairable	Reed	Excel Worksheet Functions	4	January 20th 05 07:15 PM

All times are GMT +1. The time now is 06:13 PM.

Menu

About Us