| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert 10,000 item column into 1,000 rows by 10 columns
-- 602 952 2526 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert rows to columns | Excel Discussion (Misc queries) | |||
| Convert data from multiple columns/rows into one column - help! | Excel Worksheet Functions | |||
| convert columns to rows | Excel Worksheet Functions | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Can I convert columns to rows? | Excel Discussion (Misc queries) | |||
Hybrid Mode
