I have data in this format-
Stream 1 2 and so
on goes on until 200
Overall Name
Temperature 388.7621902 ---
Pressure 200.1991633 ---
Molar Flow 0.948850417 ---
Mass Flow 737236.0254 ---
Standard Ideal L 65030.4938 ---
Molecular Weight 97.89860257 ---
Heat Flow -187514450 ---

Vapour Molar Flow 0.11386205 ---
Mass Flow 67769.0336 ---
Std Gas Flow 8.230237895 ---
Actual Volume Flo 144377.8631 ---
Molecular Weight 74.99287269 ---
Heat Flow -30294681.9 ---

I basically need to transpose this data but in this format....since
there are two molar flow and and mass flow and so on for Overall and
Vapour i need them to be displayed in two different lines...

Stream Temperatur Pressure Molar Flow Heat
Flow Actual Volume Flow

1 388.7621902 200.1991633 0.948850417 -187514450 NONE
Vapour .
11386205 -30294681.9 14.34423651
2 --- --- --- --- ---
Vapour --- --- --- --- --- There is no data available
for Stream 2.


It will be great some one would help me out with the code to transform
my data into the above format in such a way that i can add more
properties....THANK YOU VERY MUCH ....