View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default changing columns

David McRitchie has some notes on how to produce newspaper-type
columns he

http://www.mvps.org/dmcritchie/excel/snakecol.htm

Hope this helps.

Pete

On Jan 29, 8:33*pm, Pete_UK wrote:
You might want to take the data which is currently on rows 1 and 2 and
put them side-by-side, and then rows 3 and 4, 5 with 6 etc, or take
row 1 and row 91 and put those side-by-side, then 2 with 92, 3 with 93
etc.

Any preferences?

Pete

On Jan 29, 5:58*pm, Windy wrote:



How can I take data that is in three columns, 180 rows and make it 6 columns,
90 rows?- Hide quoted text -


- Show quoted text -