C
cj2k2k
What formula do I need to traspose sets of data from Sheet1 to Sheet2?
the data comes in sets of 8, sheet1 looks like this (from L3)
L M
3 POCKET 1
4 DIE 1
5 CC-AUTO 12
6 CC-CALC 4
7 EB 3
8 CC-FLOW 6
9 EB-FLOW 1
10 Total Void 42
11 POCKET 2
12 DIE 1
13 CC-AUTO 23
14 CC-CALC 0
15 EB 2
16 CC-FLOW 12
17 EB-FLOW 2
18 Total Void 37
Sheet2 needs to look like this (from C7)
C D E F G H I J
7 POCKET Die CC-AUTO CC-CALC EB CC-FLOW EB-FLOW Total
Void
1 1 12 4 3 6 1 42
2 1 23 0 2 12 2 37
I want to look for a match the Headers on Sheet2
("POCKET","Die","CC-AUTO","CC-CALC","EB","CC-FLOW","EB-FLOW","Total Void") in
Sheet1, Column L3+ and get the value of Column M3+.
This is what I have working so far..
=OFFSET('Sheet1'!$L3,MATCH(C7,'Sheet2'!$L:$L,0)*0,1)
How do I make this formula skip every 8 rows?
Thanks,
CJ
the data comes in sets of 8, sheet1 looks like this (from L3)
L M
3 POCKET 1
4 DIE 1
5 CC-AUTO 12
6 CC-CALC 4
7 EB 3
8 CC-FLOW 6
9 EB-FLOW 1
10 Total Void 42
11 POCKET 2
12 DIE 1
13 CC-AUTO 23
14 CC-CALC 0
15 EB 2
16 CC-FLOW 12
17 EB-FLOW 2
18 Total Void 37
Sheet2 needs to look like this (from C7)
C D E F G H I J
7 POCKET Die CC-AUTO CC-CALC EB CC-FLOW EB-FLOW Total
Void
1 1 12 4 3 6 1 42
2 1 23 0 2 12 2 37
I want to look for a match the Headers on Sheet2
("POCKET","Die","CC-AUTO","CC-CALC","EB","CC-FLOW","EB-FLOW","Total Void") in
Sheet1, Column L3+ and get the value of Column M3+.
This is what I have working so far..
=OFFSET('Sheet1'!$L3,MATCH(C7,'Sheet2'!$L:$L,0)*0,1)
How do I make this formula skip every 8 rows?
Thanks,
CJ