Eg. I have a table which displays 40 different reasons. Now I want to label them down to 5 main categories then is it possible to display this in metabase?
Add custom column in the Data section ? 
https://www.metabase.com/learn/building-analytics/notebook-editor/custom-expressions.html