Sorting ready for mailmerge

[The Bodster]

How do I sort a sheet (say 10 rows of 5 columns) into 1 row of 50 columns,
where each 5 columns in the new single row is made up of the successive rows
of 5 columns of the original data? I don't want to cut and paste.

Cheers,

B.

 

[Debra Dalgleish]

Why do you need to do this to prepare for a mail merge? Your current
layout sounds better.

 

[Dave Peterson]

You may want to read some tips for mailmerge:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.