How to transpose data to change row into column using IDEAScript

Hello, i want to ask on how to code using IDEAScript to transpose data from row to column. here is the scenario :
I got an excel source data and the first row can't be used as field name while each row that has data is divided with blank row one after another. the writing format is like form with first column contains form labels and second is the answer. i put the screenshots of the expected result if i transpose the data below. i also put the test file below.
Is there a way to script this kind of data transpose in IDEA? 
Thank you.