Last seen: Jul 8, 2026
Remember the PQ parameters are zero-indexed. So, a zero will extract text after the first occurrence of the "-", a 1 will take the second, a 2 will ta...
Aha! Remove that Promote header step. Don't know whare that comes from. In the Advanced Editor the code of the Sample File should look like this: ...
Hard to tell. The files you uploaded definitely have hyphens. Can only wonder why there aren't there on your system. But I see another problem now...
See attached. The problem was caused by the hyphens in two of the file names. That messed up the extraction process. Just replace the "-" in Medica...
Let's start over and forget my message number 2. In the beginning of message 6, I tried to explain that I had made a mistake. But I guess I wasn't cle...
Hi Lea, I looked at both videos. Forget about the first one. You don't need to "Remove Other Columns" before combining the Content column. I did th...
Hi Lea, I'm not really used to making videos, but Mynda is. Did you check out this video? I think it cover it all. Riny
Hi Tom, To avoid the elimination of "General contingency" is easy. Just include the Heading column to the equation so that PQ looks for duplicates ...
Hi Kenneth, Try it this way: =W6#-((INDEX($Y$6#,$A$6#)=1)*(INDEX($X$6#,$A$6#)>40)) Your formula will always give TRUE if all numbers in X ...
Sure thing. Come back here if you need more help. R
Okay, I hadn't noticed these two columns at the end. Please have a look at the attached revised workbook.
Good morning Tom, Okay, I see. Then you do two merges. First Original with Revised, Then Revised with Original. Append the two, remove duplicate de...
Not able to spend time on this now, but try a FullOuter join. Come back if that doesn't work. Otherwise, I'll have a closer look tomorrow, my time (i....
The trick here is to first define a named range of the data you want to use. Connect to that range with PQ and Transpose the table. Now merge the firs...
Have a look at the attached file. Both Pivot tables can basically be the same. On one you collapse the Heading field. On the other you Expand the Head...