Re: [belajar-excel] Power Query excel

AKHMAD Page: 1
S T O C K M O V E M E N T D E T A I L R E P O R T B Y P R O D U C T

I N O U T
--------------------------------------------------------------------------- ---------------------------------------------------------------------------
WH D A T E SYS BATCH REF/DOC CUSTOMER/SUPPLIER MRN/CUST PO/PRIMARY # LN# BEG.BAL. PURCH RET GOODS WH TRNSF PROD TRNSF MANUFACT ADJUST STOCK TAKE SALES RET GOODS WH TRNSF PROD TRNSF REQN ADJUST STOCK TAKE BALANCE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
P R O D U C T # 3 2 7 9 / 2 4 0 3 2 7 9 - K G


02 04/09/2020 000482885 00055697 XXXX YYYY, PT PO 14638 VDR 20140 001 480 480
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
TOTAL PRODUCT ----> 0 480 480

TOTAL IN DRUMS ---> 0.00 2.00 2.00

P R O D U C T # 3 9 3 5 / 1 2 0 0 3 9 3 5 - K G


02 02/09/2020 000482737 00055661 AAA BBB, PT PO 14622 VDR 20140 001 1,200 4,800 6,000
02 04/09/2020 000482883 00055695 AAA BBB, PT, PO 14622 VDR 20140 001 6,000 7,200 13,200
02 07/09/2020 000482969 00055718 AAA BBB, PT, PO 14642 VDR 20140 001 13,200 1,200 14,400
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
TOTAL PRODUCT ----> 1,200 13,200 14,400

TOTAL IN DRUMS ---> 1.00 11.00 12.00

Maaf mas Kid,

Jd malu sepertinya attachmentnya ada yg salah, terlampir sumber data dan hasil dlm excel yg diinginkan

salam

sodik