I have a table that stores a comma separated list of key value pairs for permissions. E.g 45:902,45:61,51:203,51:208 etc. I'm trying to parse a single record row so that I get a record set of ...

Is there anyway I can make it so if I copy and paste those comma separated list into it excel it automatically puts each thing into different fields.