csv manipulation question

[fally]

HI,
I'M a bit of a newb to all this, and was wondering if the following wa
possible. Sorry if this is a repetative question, as i have used th
search facility and not found an obvious answer.

I have a large csv file which i would like to re-format to look like
spreadsheet.
A portion of the data is as below




Point System Name: MS.AH9029.DEHUM.OP
Point Name: CC-9716.DEHUM.OP
Point Type: LAI
Classification: Building Automation
Descriptor: CC-9716.DEHUM.OP
Panel Name: MS.OSN11
Point Address: -Virtual-
Sensor Type: Voltage
Slope: 1
COV Limit: 1
Engineering Units: %rH
Analog Representation: Float
# of decimal places: 2
Initial Value: 0
Totalization: None
Enabled for RENO: No
Graphic Name: <Undefined>
Informational Text: << No Text Defined >>
Alarm Type: Not Alarmable


********************************************************************************

Point System Name: MS.AH3098.DEHUM.OP
Point Name: CC-3098.DEHUM.OP
Point Type: LAI
Classification: Building Automation
Descriptor: CC-3098.DEHUM.OP
Panel Name: MS.OSN12
Point Address: -Virtual-
Sensor Type: Voltage
Slope: 1
COV Limit: 1
Engineering Units: %rH
Analog Representation: Float
# of decimal places: 2
Initial Value: 0
Totalization: None
Enabled for RENO: No
Graphic Name: <Undefined>
Informational Text: << No Text Defined >>
Alarm Type: Not Alarmable


********************************************************************************

As you can see, each record is separated by the long line o
asterisks.
Is it possible to have a list of records, with the data for each recor
(which is currently field2) stored in a row and have field 1 (Pointname
point system name,point type, etc) as column headings?
I have approx 700 records and in the above format it is not easy t
review easily
Any help gratefully recieved.
Thanks in advance
Fall

 

[Guest]

1. copy your .csv file to a .txt file (this will get you the wizard when you
open it)
2. when you open the file, tell the wizard to use the colon ( : ) as the
field separator
3. select the first group of descriptions ( Point system name, point name,
....) and copy it.
4. go to the destination worksheet and paste the data Special with transpose
selected ( this will create a row)
5. go back to the source worksheet
6. Successively copy each block of data (column B) and paste it transpose to
the destination sheet