Excel 2010 - Macro to join 5 rows with multiple cells to one row

I have a spreadsheet with five rows and multiple cells that I would like to combine to one row. Can someone help me with a macro? There are approximately 200 rows in my spreadsheet and I don't want to have to do this individually to each set of data.The data was downloaded as text.

I am new to macros - sorry

Example of spreadsheet:

a b c d e
f g h i j
k l m n o
p q r s t
u v w x y
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
etc.
I would like it to look like:

Row 1 would be: a b c d e f g h i j k l m n o p q r s t u v w x y
Row 2 woudl be: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Thanks.

Thanks. It worked on my sample document so I will try it on the real spreadsheet at work in the morning.

Have a great evening.
Fiesty

Harry, it worked on my sample spreadsheet - will try on the real spreadsheet tomorrow.

Thanks so much for your help.
have a great evening.
Feisty