Forum Discussion
Consolidating data from different sources
Hi all, I've just joined the community and had a look but can't see a previous answer. I have 2 sources of data that I need to consolidate into a single master workbook, but the data updates each m...
Some good advice given bymathetes and SergeiBaklan.
I think as long as you keep the data clean (Normalized with no dupes or redundancy) then Excel offers a lot of flexibility (Especially if you go with Power Query).
My recommendation for getting started in Power Query. Pick a few simple tasks to get started like 1. un-pivoting data and 2. combining multiple sheets into 1.