To be able to avail of the benefit of the collective experience that the monks have and take a rewarding educational leap you've got to make sure you provided enough details representing your problem communicated through : That way you will be able to identify strengths and weaknesses in your approach, patch up and polish the code you write and be able to help those who respond to your query so that they provide to you a suitable approach in line with your skills for you to build upon. You will also get to help others who are coming after you up the path to monkeyness by posting questions that will stand the test of time because they're wholesome, clear and concise. So when you say
'I'm not able to convert'
you're being unclear for you've not mentioned what you have tried to do so far to accomplish this task.

The above list is not exhaustive....Also take time to read:

Excellence is an Endeavor of Persistence. A Year-Old Monk :D .

In reply to Re: converting rows into column by biohisham
in thread converting rows into column by changma_ha

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.