Sorting ready for mailmerge

  • Thread starter Thread starter The Bodster
  • Start date Start date
T

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.
 
Why do you need to do this to prepare for a mail merge? Your current
layout sounds better.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting 1
Sorting problem 3
Transpose, but how? 0
Sorting several columns 1
Sort / Copy Macro 2
Cell reference value to remain constant in a sort using Paste Link 2
Value used in a Paste Link to remain constant during a sort 1
Sorting multiple rows... 4

Back
Top