Merging Data from Multiple Worksheets into Single with Non-Matching Headers

%3CLINGO-SUB%20id%3D%22lingo-sub-1329343%22%20slang%3D%22en-US%22%3EMerging%20Data%20from%20Multiple%20Worksheets%20into%20Single%20with%20Non-Matching%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329343%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20collecting%20a%20large%20amount%20of%20data%20from%20multiple%20sources%20with%20inconsistent%20data%20reporting%20(i.e.%20naming%20conventions%2Fetc.).%20In%20order%20to%20preserve%20the%20main%20source%20formatting%2C%20for%20the%20purpose%20of%20copying%20and%20pasting%20future%20data%20with%20ease%2C%20I%20have%20created%20three%20separate%20worksheets%20in%20the%20Master%20Data%20file%20(attached)%20named%20%22Concrete%20Qty_(PC-IE)%22%2C%20%22Cocrete%20Qty%20(Tekla)%22%2C%20and%20%22Steel%20Qty%22.%20I've%20watched%20and%20read%20a%20few%20tutorials%20on%20Get%20and%20Transform%20in%20the%20Power%20Query%20which%20seems%20like%20the%20best%20way%20to%20merge%20all%20this%20data%20into%20a%20single%20worksheet%2C%20titled%20%22Master%20Data_Layout%20Test1%22%2C%20but%20am%20having%20troubles%20executing%20this.%20I'd%20like%20to%20take%20the%20raw%2C%20inconsistent%20data%20then%20merge%20it%20and%20format%20into%20a%20more%20easily%20digestible%20format%20to%20review%20First%20off%2C%20is%20it%20possible%20to%20simply%20combining%20all%20these%20data%20into%20a%20single%20worksheet%20with%20varying%20column%20headers%3F%20The%20final%20intent%20is%20to%20be%20able%20to%20analyze%20all%20this%20data%20for%20trends%2Fetc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAustin%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1329343%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

 

I am collecting a large amount of data from multiple sources with inconsistent data reporting (i.e. naming conventions/etc.). In order to preserve the main source formatting, for the purpose of copying and pasting future data with ease, I have created three separate worksheets in the Master Data file (attached) named "Concrete Qty_(PC-IE)", "Cocrete Qty (Tekla)", and "Steel Qty". I've watched and read a few tutorials on Get and Transform in the Power Query which seems like the best way to merge all this data into a single worksheet, titled "Master Data_Layout Test1", but am having troubles executing this. I'd like to take the raw, inconsistent data then merge it and format into a more easily digestible format to review First off, is it possible to simply combining all these data into a single worksheet with varying column headers? The final intent is to be able to analyze all this data for trends/etc. 

 

Thank you for the help.

 

Austin 

0 Replies