Combine Multiple Excel Worksheets with Drop-down Alpha Characters and Analyze Data

%3CLINGO-SUB%20id%3D%22lingo-sub-2278345%22%20slang%3D%22en-US%22%3ECombine%20Multiple%20Excel%20Worksheets%20with%20Drop-down%20Alpha%20Characters%20and%20Analyze%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278345%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20and%20Help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20O%2FS%20Microsoft%20Windows%2010%2C%20MS%20365%20Excel%20version%202103%2C%20Build%2013901.20336.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20the%20easiest%20way%20to%20combine%20multiple%20worksheets%20with%20drop-down%20selection%20of%20alpha%20characters%20in%20each%20column%20to%20determine%20the%20mean%2C%20medium%20or%20anomaly%20for%20each%20task%20row.%26nbsp%3B%20Using%20the%20data%20consolidate%20function%2C%20it%20converts%20my%20alpha%20data%20to%20numerical%20data%20by%20counting%20the%20number%20of%20data%20fields.%26nbsp%3B%20I%20tried%20using%20the%20pivot%20table%20and%20filtering%20functions%2C%20but%20there%20is%20a%20lot%20of%20manual%20manipulating%20required%20to%20consolidate%20the%20worksheets.%20The%20attached%20worksheets%20have%20a%20separate%20tab%20with%20the%20list%20of%20drop-down%20selection%20for%20each%20column.%26nbsp%3B%20If%20there%20is%20no%20solution%20using%20excel%2C%20please%20recommend%20an%20alternative%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPraying%20for%20a%20Miracle.....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278345%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Greetings and Help!

 

I am using O/S Microsoft Windows 10, MS 365 Excel version 2103, Build 13901.20336.

 

I am trying to find the easiest way to combine multiple worksheets with drop-down selection of alpha characters in each column to determine the mean, medium or anomaly for each task row.  Using the data consolidate function, it converts my alpha data to numerical data by counting the number of data fields.  I tried using the pivot table and filtering functions, but there is a lot of manual manipulating required to consolidate the worksheets. The attached worksheets have a separate tab with the list of drop-down selection for each column.  If there is no solution using excel, please recommend an alternative option.

 

Praying for a Miracle.....

0 Replies