Copying data from another sheet

[n00bz0rd2]

Hi all,

I'm trying to copy data and reformat it from one sheet to another and running into some problems.

(Note: the row/column numbers are different on my actual sheets)

I have Sheet1 setup as follows:

	A	B	C	D
1		WK1	WK2	WK3
2	Product 1
3	Value	£5787	£1211	£4431
4	Volume	578	121	443
5	Product 2
6	Value	£1,397	£1,382	£1,170
7	Volume	1397	1382	914
8	Product 3
9	Value	£981	£1,079	£1,144
10	Volume	981	1082	1148

<tbody>
</tbody>

On sheet 2, I want to re-organise the data into a better format as I will need to add more information, which the design on Sheet1 doesn't allow.

	A	B	C	D	E	F	G
1		WK1		WK2		WK3
2		Value	Volume	Value	Volume	Value	Volume
3	Product 1	5787	578	1211	121	4431	443
4	Product 2	1397	1397	1382	1382	1170	914
5	Product 3	981	981	1079	1082	1144	1148

<tbody>
</tbody>

So I have a formula in sheet 2 that looks up values from Sheet 1, for both the Value and Volume figures. This works fine and I can copy the formula down for each product:
=OFFSET(Sheet1!B$3,(ROW(Sheet1!$B3)-5)*3,0) would be in B3
=OFFSET(Sheet1!B$4,(ROW(Sheet1!$B3)-5)*3,0) would be in C3

When I copy the formula across, the formula skips columns. Is there a way I can avoid this?

Hopefully this is make sense!

Thanks.