rearranging rows from a single column

G

Gary

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
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rearranging Data 0
Format column widths from one table to a separate table on same page 1
Possible to Combine reports to's to a single box? 0
Compare identifier columns from 2 sheets - remove rows that are dups 2
Copy column and rearrange rows 5
Graphing Question: Blank Lines Problem ? 2
Remove punctuation mark, Split cells & average accross column 4
Missing task list row and columns Lines along with Ganttchart non working day color 0

Top