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 |
rearranging rows from a single column
If you have your data in Col A of Sheet1 then put this in A1 of Sheet2
=INDIRECT("Sheet1!A" & (COLUMN()-1)*20+ROW()) and copy it across and down as needed It will put A1-A20 in Col A of Sheet2, A21-A40 in Col B, A41-60 in Col C and so on "Gary" wrote: 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 |
All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com