Tableau For Loop a String

Question

I have the table below. As I have numerous firstnames in the same column, I cannot convert the json data into many computed fields. Please refer to the example below to see what I'm aiming towards. I appreciate you helping me.

School	StudentJson
Middle School	[{"firstname":"John","lastname":"doe","firstname""Patrick","lastname":"mahomes","firstname":"steve","lastname":"segal"}]
High School	[{"firstname":"tom","lastname":"brady","firstname""jason","lastname":"fred"}]

Final Result

School	firstname	lastname
Middle School	John	doe
Middle School	Patrick	mahomes
Middle School	steve	doe
High School	Tom	segal
High School	Jason	Fred
High School	John	doe

I have tried using a forloop and split but it didnt work

Answer 1

In the case of

[
   {
      "firstname":"tom",
      "lastname":"brady",
      "firstname":"jason",
      "lastname":"fred"
   }
]

You have all the paramaters under the same object. Does changing your json to be

[
   {
      "firstname":"tom",
      "lastname":"brady"
   },
   {
      "firstname": "jason",
      "lastname":"fred"
   }
]