Hi All, this seams so easy but i just can't figure it out!!

I have list of names and addresses in a column, they are in groups of five e.g. cell A1 - Name, A2 - Address 1, A3 - Address 2, A4 - Address 3, A5 - Postcode.
What i need to do is copy the first group of five and then transpose, then move down to the next group of five and transpose and so on till the end of the column.

Any help would be greatly appreciated.

Thanks

Dean