Excel Question, Is this possible?
I hope someone knows whether this is possible or not and how to do it if it is...
I'm trying to organise my data in an excel spreadsheet, I have imported raw data to one sheet and am now trying to organise it into something that I can actually make sense of.
So the raw data is on sheet 2, I'm editing sheet 1
in cell a1, I'm referencing 'sheet2!a1'
in cell a2, I'm referencing 'sheet2!a4'
in cell a3, I'm referencing 'sheet2!a7'
...
and so on, this is for about 300lines of data on sheet 1, so there is about 900 lines of data on sheet 2. I thought there was a way where I can set a value and it will skip to every third cell when I drag the formula down but I can't get it to work. I've tried filling in the first three cells then highlighting all three and dragging to fill the column, but that doesn't work, it gives alot of repeat data. I've tried it with and without CTRL as well.
Any suggestions?