Data transformation from rows to columns

[Alonso]

Hello,

I have a txt file that gives me the data as shown below, but even I try to import it into SAS JMP it only gave me two columns with the data. I'll like to know if there is  a way to use the first column as the column name and the second part after ":" as my data it self. I have multiple files and once I'm able to rearrange the data I'll concatenate them row after row.

Data from .txt:

Comment:         

Operator:           

BD:     D_C

TS:        2014-05-02T05:22:08.3119997

CFile:     C_2014_04_24-11_30_39_M2.ini

File:          20140423-PRD.ini

LTemp: 23.0

FCW:    

I :       -0.00047565

eta [%]:                NaN

M A [m2]:            0.65300

This is how I'll like to see it...

Comment:	Operator:	BD:	TS:	Cfile:	File:	Ltemp:	FCW:	I	eta[%]	M A [m2]
D_C	2014-05-02T05:22:08.3119997	C_2014_04_24-11_30_39_M2.ini	20140423-PDR.ini	23	NaN	0.653

Thank you

[PGStats]

If this is a question about JMP, you should post it to the JMP User Community at

Welcome | JMP User

PG