Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine seperate rows into single column | Excel Discussion (Misc queries) | |||
deleting rows that is compared to a single column. | Excel Discussion (Misc queries) | |||
Rearranging rows & Cloumn( Please help me) | New Users to Excel | |||
Rearranging columns/rows | Excel Discussion (Misc queries) | |||
Convert rows to one single long column? | Excel Discussion (Misc queries) |