Jayapresad
New Member
Dear Friends,
I would like to get your suggestions to solve the following problem by using M Code or power query.
How to pack the items of Table 1 in minimum number of carton subject to
1. Total weight in a carton should be max of 25 kgs.
2. In a caton max 5 items can be inluded.
3.The final table to be sorted from smallest to largest based on Pack No.
Thanks
JP
This problem already posted in myonlinetraininghub forum also.
https://www.myonlinetraininghub.com/excel-forum/power-query/conversion-of-table-by-using-power-query
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
MOD EDIT: Thread moved from PQ forum as there is no appropriate solution to the problem using PQ. Thread title changed to more closely match issue at hand.
I would like to get your suggestions to solve the following problem by using M Code or power query.
How to pack the items of Table 1 in minimum number of carton subject to
1. Total weight in a carton should be max of 25 kgs.
2. In a caton max 5 items can be inluded.
3.The final table to be sorted from smallest to largest based on Pack No.
Thanks
JP
This problem already posted in myonlinetraininghub forum also.
https://www.myonlinetraininghub.com/excel-forum/power-query/conversion-of-table-by-using-power-query
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
MOD EDIT: Thread moved from PQ forum as there is no appropriate solution to the problem using PQ. Thread title changed to more closely match issue at hand.
Attachments
Last edited by a moderator: