Forum Discussion
Aeraxon
Dec 01, 2020Copper Contributor
Power Query - Please help me match changing values with logic
Hello Together, this is my first activity here. I hope, I am doing everything right and describing everything corretly and understandable. At first I describe my source data, then what I am doin...
Riny_van_Eekelen
Dec 01, 2020Platinum Contributor
Aeraxon Certainly possible. With your file to play with, I suggest you try this:
In PQ, sort your date first by Flight number, then by Registration number. Now I can't remember if the Registration numbers will show at the top or bottom of the each group of flight numbers . If at the top, use Fill down or if at the bottom use Fill upp.