Forum Discussion
Seedling distribution
ms_mit Great you could get it to work. And what's 15 minutes for a job that would otherwise take perhaps a whole day of copying and pasting. Now that I look back at the query, I see I was over-thinking the matter by adding the Grouped Running Total. We can do without and it will probably speed up the process. See attached.
ms_mit Since you mention to have 1.3 million seedling to distribute to 8000 farmers, you should look into Power Query. Played around a bit with your example and came up with a "solution" that needs refinement. Half of it is in PQ. For the other half I cheated a bit by adding some manual columns in Excel. Should be possible to do those in PQ as well but have the inspiration right now.
HiRiny_van_Eekelen I had a look at your PQ setup and I have to admit that for now it is over my head but I will come back to it and learn it. In the mean time, I wonder If I could ask you if you have any ideas for an alternate solution. I am using this data as the basis for printing labels for all the bags of seedlings and it would be more workable to put the species in the shared bags in a single row, rather than more rows of the same bag number. I have attached a file with the structure I am talking about. If it you have a quick idea how to do this, I would very much appreciate it.