NEED HELP!!! Consolidate Similar looking data and count them in different sheet

[preethamdevraj]

Hello,

I am using Excel 365 and trying to consolidate similar data in one column and count them in the column to the right. I have attached the data sheet and desired results as well. I have run this data every day and I have been doing it manually.
Here is the Google sheet link for the data
Attached is the picture of the Desired Result:

Any help from the Gods of Excel in this communicty would be of great help.....

 

[Peter_SSs]

Here is the Google sheet link for the data

Welcome to the MrExcel board!

• There is no link.
• Is this a Google Sheets question?

What about using XL2BB so that helpers can easily copy your data/results for testing?

 

[preethamdevraj]

Hi I am sorry, I just uploaded the data to a google sheet for reference.

All cases with categorization

Raw data Case Record Type,Case Reason,Reason Description Company 1,No Selection,No Selection Company 1,No Selection,No Selection Company 1,No Selection,No Selection Company 1,No Selection,No Selection Company 1,No Selection,No Selection Company 1,No Selection,No Selection Company 1,No Selection,...

docs.google.com

@Peter_SSs

 

[Peter_SSs]

Sorry, I don't intend to manually investigate 7000+ rows of data to try to work out what you want done. Can you make a much smaller sample that still demonstrates what you want and also explain how the consolidation is done manually? Then I could at least consider if I have a solution method.

You will also get more potential helpers if you provide the data/results with XL2BB as many people will not go to another site to download an unknown file, or are prevented from doing so by workplace security measures.