| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rather complicated table to consolidate
I have try to use pivot table to consolidate the data of the data below.
However, it is to complicate and I've lost. Any one could help me? soure data : "Doc:",":","1234" "Cost","',"","Amount" "Nil" "Doc",":","","1235" "Cost","","","","Amount" "CC","","","","230.50" "DD","","","","135" "EE" "Total","","","","HKD12/pc" "Doc:",":","","1236" "Cost","","","","Amount" "CC","","","","220" "EE","","","","145" "Total","","","","USD14/pc" Expect result Doc CC DD EE Total 1234 1235 230.50 135 HKD12/pc 1236 220 145 USD14/pc I wish someone could help me out. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Threaded Mode
