Quick excel help

Associate
Joined
3 Dec 2002
Posts
618
Location
Sydney, Australia
Hi guys,

I'm trying to reorganise some data in Excel - I'm sure its possible to do what I want, I just don't know how :)

excel.png


Basically I have about 500 rows of data under the header list in the format:

<blank line>
<blank line>
1
2
3

This repeats throughout as seen on the left side of the image - what I want to do is move that data to the format shown on the right hand of the pic - with 3 different columns for each row. How can this be done?

Thanks a lot,
 
Hi div0,

Thanks for the reply - I've actually managed to do it using

=OFFSET($A$1,(ROW()-1)*5+INT((COLUMN()-3)),MOD(COLUMN()-3,1))

It returns the blank lines as 0 but I can easily cut them out (or do a find/replace).

There's a second bit I now need to do but I'll try and sort that myself before asking here again :)

Cheers,
 
Back
Top Bottom