I will preface this with I am brand new to Excel Power Query, just learned about it last night and made my source folder containing the csv files to merge (5 total – 2020, 2021, 2022, 2023,2024 (Current year data)). I got them successfully merged and into the output table in excel. All of the data is there.