資料整理-EXCEL

Item: 8000.0001             Category: RM

            Adjustment                         |-------- Unit Cost --------| |------- Extended Value --------|
Subinventory    Quantity UOM Cost Element                   Old          New             Old             New    Adjustment
------------ ------------ --- -------------------- -------------- -------------- ---------------- ---------------- ----------------
MM             35.0000 KG  Material             5,700.00000 5,400.00000       199,500       189,000       -10,500
MB             12.0000 KG  Material             5,700.00000 5,400.00000          68,400          64,800          -3,600
                                                                                                                  ----------------
                                                                                                Item Total:             -14,100
                                                                                                                  ================

改成
Subinventory    Quantity UOM Cost Element                   Old          New                         Old             New    Adjustment    ITEM                               CATEGORY
MM                      35.0000 KG    Material             5,700.00000 5,400.00000       199,500       189,000       -10,500 8000.0001                            RM
MB                      12.0000 KG    Material             5,700.00000 5,400.00000          68,400             64,800          -3,600 8000.0001                            RM

請問大大們,該如何處理才能迅束的變成上面的格式,以利我去作成樞紐分析表?