need formula for trasposing data between 2 sheets

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top