Help with consolidating data and expenses from multiple worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2428424%22%20slang%3D%22en-US%22%3EHelp%20with%20consolidating%20data%20and%20expenses%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2428424%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20help%20on%20how%20to%20consolidate%20data%20and%20expenses%20from%20multiple%20worksheets%20into%20one%20worksheet.%20All%20of%20the%20worksheets%20have%20identical%20labels%20in%20the%20first%20row.%20The%20rows%20below%20the%20header%20row%20aren't%20consistent%20because%20each%20person's%20invoice%20is%20different%20and%20everyone%20doesn't%20work%20the%20same%20amount%20of%20time.%20I%20need%20the%20data%20(School%20affiliation)%20as%20well%20as%20the%20expenses%20under%20the%20various%20columns.%20I%20am%20not%20fluent%20with%20this%20type%20of%20analysis%20and%20have%20tried%20a%20variety%20of%20things%20but%20haven't%20been%20successful.%20I%20have%20some%20analysis%20and%20pivot%20tables%2C%20but%20not%20the%20exact%20one%20that%20I%20need.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2428424%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am looking for help on how to consolidate data and expenses from multiple worksheets into one worksheet. All of the worksheets have identical labels in the first row. The rows below the header row aren't consistent because each person's invoice is different and everyone doesn't work the same amount of time. I need the data (School affiliation) as well as the expenses under the various columns. I am not fluent with this type of analysis and have tried a variety of things but haven't been successful. I have some analysis and pivot tables, but not the exact one that I need. Thanks

0 Replies