Sorting

  • 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.
 
hi,
Sorry. sort doesn't work that way.
you can do with copy paste special tranpose
it would take you 5 pastes.
assuming your date is at A1:E10, copy the a column then
select end of data at row 1. goto edit>paste special>
choose transpose
repeat for the other 4 columns.
sorry.
Regards
Frank
 
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 ready for mailmerge 2
Sorting problem 3
Transpose, but how? 0
Sorting several columns 1
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
Sort / Copy Macro 2
Sorting multiple rows... 4

Back
Top