convert 10,000 item column into 1,000 rows by 10 columns
 

--
602 952 2526

convert 10,000 item column into 1,000 rows by 10 columns
 

Post about 20 data samples.
--
Gary''s Student


"McDuck" wrote:


--
602 952 2526

convert 10,000 item column into 1,000 rows by 10 columns
 

Is this so you can print and save some paper?

If yes:

David McRitchie has a macro that will "snake" the columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

Personally, I'd copy into MSWord (maybe hitting NotePad if MSWord slows down
when I paste).
Then use MSWord's Format|Column to make life easy.



McDuck wrote:

--
602 952 2526

--

Dave Peterson