Dear Master Excel, Saya punya masalah sebagai berikut ada data pemakaian spare part bulan dengan dg susunan tabelnya : 1. Control no 2. Date 3. Item no 4. Descript no 5. Categori 6. Qty 7. Unit 8. Amount 9. Cost
Dari tabel tersebut saya ingin ringkasan yg terdiri : 1. Kolom pertama berisi control no (header) dan baris kedua dst berisi control no 2. Kolom kedua sampai kolom ke 31 berisi date (header) dan baris kedua dst berisi cost dari categori yg dipakai berdasarkan date dikeluarkannya spare part tsb. 3. Data ini sebagai key adalah categori Terima kasih atas pencerahannya. Hormat saya, Samsudin Dikirim dari perangkat Samsung E7 saya --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy.
