Thanks for time and help, Philip. Your points are well taken. Looks like I'll have to go back to the drawing. The only solution is probably what I ...
Thanks so much, Philip. Such a simple solution! I apologize for the late follow-up. I had surgery a week and a half ago and have been slowly r...
Thanks so much, Mynda. This helps me out a LOT. I really appreciate your time.
Thanks. I'm adding a sample file. Basically, I'm try to add some tags to the (Keywords) table via a conditional column. The problem is inputti...
I don't think merge will work because it's really a search function. Searching for a partial match with the text in a different column. It's not an ex...
Sorry, that's what I meant -- changing data types. Those formats (i.e Number, currency) don't stay applied when I load data from PQ to table.
Thanks Catalin. Sometimes my ideas get ahead of what's actually possible. i appreciate your feedback
Hi Mynda, Thanks for responding. I'm attaching an excel file that will hopefully make my question more clear. In the attachment, The 'Blocksprin...
Awesome! Thanks do much for your help, Catalin. I will tinker around with this and see what I can do. The VBA idea sounds interesting. I don't k...
Thanks Catalin. I'm using PQ almost exclusively to extract data. I know that the data shaping/transformation features are powerful, but that's way ...
