Sorting

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.
 
E

Earl Kiosterud

Bod,

What you're asking for isn't really a sort. Sort simply rearranges rows
sequentially. A macro can rearrange the data. But I recommend you first
look at what Excel tools you may be needing to use against this data (pivot
tables, filtering, subtotaling, sorting...). If you'll give examples of
what the data is, perhaps we can help. Set your newsreader for a
non-proportional font if you'll be including any layout of the data in your
post.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net

For a video that will certainly make you smile,
http://www.smokeylake.com/snbrussels.mpg. It's about an expectant father
who gets on a plane, and the airline staff. About 3 meg.
 
Top