You should take a look at the Excel exporter module in the Appstore, I think you'll be able to achieve what you want with it.
Through excel exporter I am able to export the data column wise.
is there any way to do it ? basically its like a bank statement generation of form in excel.
Any idea ?
The Excel Exporter is indeed column based, but going by the image you posted this seems right for your case doesn’t it? Column 1 would be ‘Initials”, column 2 “Question” etc.