Hierarchical Arrangement

[s_anr]

Can someone help me to arrange the columns given below: Note: The tree can expand as gievn in exampe and can have more values. TOP of the tree being '1' :INPUT========================================COLUMN1 COLUMN2---------------------------------------1 = TOP1-2001 = MIDDLE1-2001-2002 = BOTTOM1-3001 = ALPHA1-3001-3002 = BETA1-3001-3002-3003= GAMMAOUTPUT========================================COLUMN1 COLUMN2 ---------------------------------------1 = TOP1-2001 = TOP-MIDDLE1-2001-2002 = TOP-MIDDLE-BOTTOM1-3001 = TOP-ALPHA1-3001-3002 = TOP-ALPHA-BETA1-3001-3002-3003= TOP-ALPHA-BETA-GAMMA

 

[s_anr]

Sorry! the display was not corerct before. This is want I want :
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->






INPUT

========================================



COLUMN1 COLUMN2
---------------------------------------

1 = TOP

1-2001 = MIDDLE

1-2001-2002 = BOTTOM

1-3001 = ALPHA

1-3001-3002 = BETA

1-3001-3002-3003= GAMMA





OUTPUT

========================================



COLUMN1 COLUMN2

---------------------------------------

1 = TOP

1-2001 = TOP-MIDDLE

1-2001-2002 = TOP-MIDDLE-BOTTOM

1-3001 = TOP-ALPHA

1-3001-3002 = TOP-ALPHA-BETA

1-3001-3002-3003= TOP-ALPHA-BETA-GAMMA







<!--[if !supportLineBreakNewLine]-->

<!--[endif]-->