[Doug McLean]

Thanks to a tip from Vince, I just updated this entire workflow.
I took a bunch of the common Options and broke them down into individual Custom Columns. So now I essentially have a dropdown list for all of my common options.

Of course I have to completely re-write the Power Query to stich everything back together, but that’s the fun part.

Along the way I’ve learned how to do a couple of really cool things with PQ, like Find/ Replace from an existing table (which is pretty cool btw).

The whole process took about 3 days, and I’m now testing it out in the world.
I’ll keep you posted