Transpose Data of 4 rows to column

Hi ,


I've trivia quiz spreadsheet which has everything (question and answers) dumped into column A.

I would like to transpose/move multiple choice to column C D E F

I need to move the answers which always starts with "a." if it is multiple choice.
The questions always have ">" in it
The sheet names are same as file name and not sheet1 as BigBas' code (link below)

There are some spreadsheets with exception, if you see "1950s Classic Movies Trivia Quiz-2" there are only few multiple choice questions not all.

I've found following code on below thread which might be something i'm looking for

Re: Move data in a column to a row

http://www.excelforum.com/showthread...=1#post2894904

A macro will be good as there are around 108 files.

Appreciate your help.