Need top skill per account from delimited columns

[Anonymous]

I delimited a list of skills in one column into 4 different columns. How would I account for all different skill columns when I am trying to find the top skills per each account? I attached first three rows of my facts table

[Anonymous · Accepted solution]

Hi @Anonymous 

This looks similar to the problem in this thread. Hopefully it'll at least be a place to start.