Convert comma delimited, key-value pairs in single column into different columns
Solution 1:
if a solution outside of excel is accepted, you can just copy everything to txt file, replace the entry separator (,) with newline (crlf), then paste it back to excel and use the built-in text-to-columns option for the key-value separator (:)
then you have two columns key and value. mark the columns and copy it, use the paste special option and select transpose
