Transposing many rows and columns to one single column

Hi there, I am getting nowhere with trying to reformat the attached doc into one single column, It's a race listing of overseas marathons and I need it to look like this

Event Name
Event Date
City
Country
Entry fee
Website

in date order, one event after the other in a single column so I can flow it into a word doc ready to be designed. Can anyone help wuth the process I need to apply in Excel (I am using 2007) to get this doc into the required format?!!

Yours
A hopeful technophobe!
Danny

Hello, thanks for replying. I can get that far but the result I am looking for is to have each event stacked on top of one another in date order in a single column.
Do you know how to do this?

Thanks
Danny

Thank you! That's the format I am after! Can you tell me how you did it as I have several docs to re-format, and also, is there a way of keeping the currency and date formats when transforming?

first formula
=IFERROR(INDEX('Overseas marathons'!$A$2:$F$102,COLUMN(A1),ROW(A1)),"")

copy right and down