LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
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
Combine seperate rows into single column Will Excel Discussion (Misc queries) 1 February 11th 09 03:11 PM
deleting rows that is compared to a single column. treeroot Excel Discussion (Misc queries) 1 September 19th 08 07:21 PM
Rearranging rows & Cloumn( Please help me) Dinesh New Users to Excel 2 March 4th 08 03:10 PM
Rearranging columns/rows BernieH Excel Discussion (Misc queries) 1 February 9th 06 09:16 AM
Convert rows to one single long column? Spalding Excel Discussion (Misc queries) 2 November 21st 05 01:39 PM


All times are GMT +1. The time now is 02:47 PM.

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

About Us

"It's about Microsoft Excel"