| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula for trasposing data between 2 sheets
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula for trasposing data between 2 sheets
Please disregard....post incomplete
"cj2k2k" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with a formula pulling data from mutilple sheets | Excel Discussion (Misc queries) | |||
| Using Data From Different Sheets Via Formula/ae | Excel Discussion (Misc queries) | |||
| FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA | Excel Discussion (Misc queries) | |||
| How can i use data from multiple sheets in a formula? | Excel Discussion (Misc queries) | |||
| copy data between sheets, but not the formula | Excel Worksheet Functions | |||
Linear Mode
