How to merge Excel worksheets

It’s often necessary to merge data in Excel if you want to compare it and run analyses. This can quickly get messy though, depending on what kind of data you have in your worksheet. Find out here how to use the Consolidate function as well as the Power Query Editor to…