I’m really struggling to find a solution to what feels fairly simple. I’ve tried iterating, aggregating, mapping and everything else under the sun I can think of, but I’m still stumped and no closer to a solution.
I have this:
And I need to turn it into this:
Basically, I can get one of the two last to columns in the first screenshot above to turn into three rows, but each row just looks like some version of this:
Also, I can get this far:
If I could get the data to link up into three instances of something like:
[operation1/bundle1, operation2/bundle!]
Or in real language:
Flat-top Goldenrod (Euthamia graminifolia) Seeds,3
Maryland Gold Crown (Verbesina occidentalis) Seeds,5
White Snakeroot (Ageratina altissima) Seeds,20
Then I think I could find my way from there to making it work. I just cannot figure out a way to do that.
