How to count distinct apps in a comma separated lists stored in rows

[Tyler_Lowe]

I have a Dashboard which uses a table that with fields which have application names separated by commas.  

Hostname | Titles | In-Service
server1 | Excel, Word, Workday, AutoCAD | Production 
server2 | PowerPoint, Word, Workday, Insight | Production 
server3 | Access, PowerPoint, Insight | Production 

In my dashboard, I would like to create a custom calculation, dimension, or measure which would list & count the distinct applications 

App | Count
Excel | 34
Word | 54
Workday | 12
AutoCAD | 4
PowerPoint | 14
Insight |5
Access | 9

Anybody know how to do this?  (I am new to Looker and trying to learn)