June 17, 2023
Is it possible to attach cells that contain data to another row based on the null value. For a project I need to export data and extract certain data which is placed below, where the actual unique identifier is placed (ID) in groups.
For the project it is crucial not to use any VBA, so I tried to think of a solution with Power Query.
But I got stuck on this problem. I just started out with Power Query so maybe there's already a article present for this exact problem. In spite of that I were not able to find a similar case (maybe I used the wrong terminology).
I hope you guys know a solution for this:
Thanks in advance!
July 16, 2010