rows to column transformation in python : <p>i have a csv file like this: </p>

<p>AVG_TP90<br>
11      </p>

<p>10      </p>

<p>6       </p>

<p>6               </p>

<p>AVG_TP65    AVG_TP80    AVG_TP90</p>

<p>20              25       31</p>

<p>16              19       28</p>

<p>12              14       16</p>

<p>11              13       16</p>

<p>USED_GB     </p>

<p>14453       </p>

<p>14045       </p>

<p>13964       </p>

<p>13753       </p>

<p>the output should be:</p>

<p>AVG_TP90    11  10  6   6
AVG_TP65    20  16  12  11
AVG_TP80    25  19  14  13
AVG_TP90    31  28  16  16
USED_GB   14453 14045   13964   13753</p>

<p>How can it be done by python code?</p>
