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.