Notifications
Clear all
Topic starter
Hello,
Can anyone explain of how to group rows in Power Query based on whether all proper cells in column "Date" contain value or not.
Example attached.
Regards,
Urmas
Posted : 02/02/2022 10:27 am
A Word document isn't particularly helpful for testing purposes - any chance of an Excel workbook?
Posted : 02/02/2022 12:20 pm
Topic starter
Hello,
I attached it.
Regards,
Urmas
Posted : 02/02/2022 2:09 pm
Here's one way. It creates a query for just the null date rows, groups by the Custom field and then converts the Explanation data into a comma separated text. That query is then merged with the original table - minus the null date rows - on the Custom field to append any new explanations.
Posted : 02/02/2022 5:55 pm
Topic starter
Thanks, it works well.
Regards,
Urmas
Posted : 03/02/2022 4:17 am