I won't weigh in with a solution as Dian Fey already did.. but a couple of thoughts.
If you have a hard time explaining the result, try giving a few examples of the desired result.
Also, may be out of your control but that text field for itemid just about breaks my heart.
Good luck getting your data out! :)
Yeah Kevin I feel the same about the column for the item but I can't change it unfortunately, it's part of a big erp system 😅 if I could, I definitely would change it 😁
Been there, done that!
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.