Forum Discussion
Merge rows based on date in excel or power query
Hello, I'm working on formatting an automatically-generated to slide into an existing excel sheet. The problem I can't seem to fix is that there exists multiple entries for flights that have mul...
For posterity: I ended up getting a solution to my problem via inspiration from a YouTube video on a similar topic. What ended up fixing the problem was I used the "group by" functionality in Power Query to match rows based on columns A:L, That ensured that all relevant data was grouped into a single row by flight event.