ETA: I’m sure this has been addressed a million times before, and I’d be glad to learn from that answer. The problem is that at this point I don’t know enough to know which of the previously posted answers is the right one. Thanks!
Continuing the discussion from Links and Schema:
I thought I had solved the problem, but no, and I can’t go back and edit the original post.
My goal still is to get output that looks like this, but with each ingredient in a separate column
Color name Mud 1 - 12% - Mud - 50 parts Blue, 24 parts yellow, 27 parts red
Color name Mud 2 - 6% - Mud - 50 parts Blue, 24 parts yellow, 27 parts red
Color name Mud 3 - 3% - Mud - 50 parts Blue, 24 parts yellow, 27 parts red
My table that has ‘ingredient summary’ as the primary field shows color names and depths of shade as a string of items instead of columnar data.
What am I doing wrong? Can this be solved without a pivot table?