View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Gary is offline
external usenet poster
 
Posts: 273
Default rearranging rows from a single column

So I have a massive amount of data I'm trying to sort which is being dumped
from a PLC (literally thousands of lines in one row). I want to make graphs
out of the data. The problem is there are 6 or 7 different parameters in this
single column. For instance, parameter 1 will show up every 20 lines. I would
like to rearrange these parameters into separate columns so i can easily
graph them. If there was some drag function i could do for each column (maybe
do = "first row"+20 then drag that down with autofill). anyone have any
suggestions? i'd like to do this without having to write a macro. Thanks