Ok you looking to do this in VBA or just with forumla as you could Count all v's and count all s's etc... or do look ups,

depends how you want the final layout really