Extremely Urgent need to arrange data

[igavini]

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 ....

 

[Zone]

Igav, the built-in Excel functions do a great job as long as there are
no conflicts in naming conventions. When you run into names like this
that appear to be the same but really refer to different things, a VBA
solution may be more useful. You could set up a new worksheet in the
workbook with headings like MolorFlowO and MolorFlowV to distinguish
between the similarly named statistics and then use VBA to slot things
in the correct column. I can't tell from your post, but evidently
there are many elements(?) compounds(?) in your list, and keeping all
the information for each on one row could make your task easier.
James

 

[igavini]

I did try the transpose feature...but it is not layed out the way i
want it...i really dont have any experience with VBA and i have been
asked to write it in VBA so i am having a little problem here...anyway
thanks for ur suggestion.