I might have not done it in the most elegant fashion, but managed to find my way around. I first loaded these values in another table using the CrossTable function:
CrossTable(Name Column,Names) LOAD [ID],[Name 1],[Name 2],[Name 3] Resident [table];
Then for display, I finally settled on a bar chart but to display individual names and count, I used the following:
I suppose there must be a better way of doing this, but for now I am glad to have arrived at the intended result.