G
Guest
What formula do I need to transpose this set of data from Sheet1 to Sheet2?
Sheet 1 looks like this:
POCKET 1
DIE 1
CC-AUTO 12
CC-CALC 4
EB 3
CC-FLOW 6
EB-FLOW 1
Total Void 42
POCKET 2
DIE 1
CC-AUTO 23
CC-CALC 0
EB 2
CC-FLOW 12
EB-FLOW 2
Total Void 37
Sheet 1 looks like this:
POCKET 1
DIE 1
CC-AUTO 12
CC-CALC 4
EB 3
CC-FLOW 6
EB-FLOW 1
Total Void 42
POCKET 2
DIE 1
CC-AUTO 23
CC-CALC 0
EB 2
CC-FLOW 12
EB-FLOW 2
Total Void 37