LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Moving data from column to row in groups of 250 per row for fourrows, then skip a row and continue the same throughout the data in column A

I am looking for help with a formula in Excel that will pull all the
data from column A on one sheet and transpose the data to a new sheet
in rows. I would like to have the data end up with 4 rows of 250
cells accross, skip a row, then the next 4 rows of 250 cells.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Breakout groups from one column of data Maarkr Excel Discussion (Misc queries) 2 October 8th 09 01:34 PM
Analysing different groups of data in the same column bananaman Excel Discussion (Misc queries) 1 November 12th 08 10:48 AM
I sort a column, how can I have all the data skip every other row Howie Excel Worksheet Functions 1 December 31st 05 03:59 PM
Data Continue to next column? Drew Excel Discussion (Misc queries) 1 January 8th 05 09:43 PM
Freezing the data in a column and moving the calculations to the next column Mervyn Thomas Excel Programming 1 December 16th 04 05:28 PM


All times are GMT +1. The time now is 03:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"