View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Make 2 long columns into 8 shorter columns

I have 2 long columns of numbers on sheet1, columns A&B, sorted descending
by column A. The number of rows of data will vary according to what is
imported. I want to put them on sheet2 for printout, in the same order but
as 8 columns wide, starting at B5. Basically it is a copy/paste the first
1/4th of sheet1, columns A:B to sheet2 B5. Then the second 1/4th of sheet1
to sheet2 E5, etc. Any ideas on how to get this started would be greatly
appreciated.
TIA, Mike