Last seen: Jul 8, 2026
Hi Remco, Can you clarify why a start date if 17 Jan 2023 would become the 2nd term with an enrolment id for the years 2023/2024? Shouldn't that be...
Hi, "that worksheet". Which one? Perhaps you could share the workbook or, at least, the code you are working on. Riny
Not sure what you mean by "PQ trying to be too efficient". As in Excel, there are many ways to achieve the same end result. Some are more efficient th...
Hi Jim, Have a look at the attached file. I 've added a query that does what you need. Key in this solution is to sort the children's first names a...
Cross-posted here:
Hi Tom, Since you specifically asked for a PQ only version, I've added such to the file. As mentioned in my response (#4 above), it's a simple Grou...
Whatever you prefer. PQ is great for big data sets, but formulas work great as well. It may be more work to maintain them when the underlying data cha...
Hi Dave, Try it with this formula in e.g. C2: =DATE(RIGHT(B2:B3624,4),LEFT(B2:B3624,2),1) It will spill an array with dates into 3623 rows fr...
The formula based solution is in the file I attached earlier. Or did I miss something?
See if the attached file works for you. I connected to the date with PQ, applied some steps and loaded the end result back to Excel (the orange table ...
OK. understood. Try attaching the file again. After adding a file, don't forget to press "Start upload" before you submit your reply.
Hi Vivian, I believe it's better that you create the "Internal External" column by adding a custom column, like this: Table.AddColumn(#"Previous...
Perhaps you'll find an solution here:
Hi Matthias, I would be helpful if you could share the link the web-site, provided it doesn't contain confidential information. Riny
Added a formula based solution to the file I uploaded with my answer to the same question, asking for a PQ solution. How can I combine kids' first ...