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 ...

Go to Data > Split texts to columns. Change separator if you want. At first, you need to select all the cells that contain comma-separated values. After that, expand the Data menu and select Split ...