How to split JSON data in a column into columns

Please refer below note for details.