I have a data with two columns. Column A contains the Engineering Change Order (ECO) numbers and Column B contains the Models affected on the particular ECO. Some ECOs with affected models are only 1 model, some ECOs are affecting two or more models. If the ECO is affecting multiple models, these models are listed only in one cell in column B separated by a comma.My objective is to create a report to find out which models have the most numbers of Engineering Change order. I have this as output in sheet 2 of the attached spreadsheet.Zippyshare.com - Sample Raw Data & Output.xlsx
1. The full raw data contains 40K rows.
2. There are no blanks rows or cells in column A and B
3. ECOs are pure number or combination of numbers and letters
Really appreciate your help.
November 21, 2013 2:21 AM
November 21, 2013 2:23 AM