Parsing data from one spreadsheet into another format

B

byork

The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016

And I need to convert this data to this format below, essentially
take the data and make it across columns instead of rows.

%AT_1300 Bottoms|Conductivity| (Water Out) 0.0 0.0 0.016 mhos VDC1to5
20.0 0.0 1.0

Thanks for the help in advanve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QAT does not allow enough room for customization - please help 2
Format a Cell from VBA 4
Moving data to another worksheet 1
OLEDB - data incorrectly = text 0
Change in "paste link" from Excel source in Word 2007? 2
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia 0
Importing from Filemaker Pro 5.0 1
Another shared workbooks question 1

Top