how to transpose every multiple rows that start with a specific string into columns using python? : i would like to ask how to transpose every multiple rows into columns and save into text file using python? I have attached input and expected output at the following part. According to the input, i would like to select every rows that starting with 'number' and then transpose into columns.

if my input and output is not clear, i had upload the images into google drive:

input image: 
https://drive.google.com/open?id=1jm5ZxtmY0xbc1wgUpnY0S88J70-UpulZ 

expected output image: 
https://drive.google.com/open?id=11xH5yzeHgQa3m6HB_JFrSq2c6l9H_lYL

and finally i would like to save expected output into text file, sorry for my poor english and thanks for anyone that able to solve it, thanks!

input:
number 
12
apple
13
banana
14
number
1
carrot
2
cucumber
3
number 
11
pen
10


expected output:
number    12     apple     13     banana       14
number    1      carrot    2      cucumber     3
number    11     pen       10