Hello Experts,
i have below source data for 2 years , each month seperately.
and i need "Qty" column wrt month in another file.
below is the format of another file..
i have below source data for 2 years , each month seperately.
Jan-25 | Feb-25 | |||||||||||||||||
Actual Purchase from External Supplier | As per calculation - internal | Jan-25 | Jan-25 | Jan-25 | Actual Purchase from External Supplier | As per calculation - internal | Feb-25 | Feb-25 | Feb-25 | |||||||||
Part number | price 1 | purchase qty | value | price 2 | Sale qty | value | total value | Qty | Prc | price 1 | purchase qty | value | price 2 | Sale qty | value | total value | Qty | Prc |
ABC | 0 | 0 | 0 | 28.66 | 1641511 | 47050374.66 | 47050374.66 | 1641511 | 28.66 | 0 | 0 | 0 | 0.00 | 626160 | 0 | 0 | 626160 | 0.00 |
XYZ | 0 | 0 | 0 | 18.26 | 502385 | 9172321.185 | 9172321.185 | 502385 | 18.26 | 0 | 0 | 0 | 0.00 | 176399 | 0 | 0 | 176399 | 0.00 |
DEF | 31.02028037 | 68400 | 2121787.178 | 2121787.178 | 68400 | 31.02 | 0 | 0 | 0 | 0.00 | 72160 | 0 | 0 | 72160 | 0.00 |
below is the format of another file..
Actual | Actual | Actual | ||||||||||
Jan-25 | Jan-25 | Jan-25 | Feb-25 | Feb-25 | Feb-25 | Jan-25 | Jan-25 | Jan-25 | ||||
Part No | Part Name | Wt | Main Product Group | Prc | Qty | Val | Prc | Qty | Val | Prc | Qty | Val |
ABC | here I need the "prc" from source file wrt month and part no | here I need the "qty" from source file wrt month and part no | here I need the "prc" from source file wrt month and part no | here I need the "qty" from source file wrt month and part no | here I need the "prc" from source file wrt month and part no | here I need the "qty" from source file wrt month and part no | ||||||
XYZ | here I need the "prc" from source file wrt month and part no | here I need the "qty" from source file wrt month and part no | here I need the "prc" from source file wrt month and part no | here I need the "qty" from source file wrt month and part no | here I need the "prc" from source file wrt month and part no | here I need the "qty" from source file wrt month and part no |