Parsing text into tables

Question

Hi

Please I have this text

{"identifiers":[{"value":"310000274","scheme":"person.v1.human-resources.university.identifiers.gmail.com"},{"value":"98bd4","scheme":"v1.person.identifiers.gmail.com"}],"namePrefixes":"Dr","surname":"Greta","forenames":"Stone","dateOfBirth":"1972-0...

and I want it to be in this format

Name prefix

surname

fornames

Data of birth

value

Dr

Greta

Stone

1972-0

310000274

Any help to transform it?

FinnCharlton · Accepted Answer

@Giantstride , this is in JSON format, which means the JSON parse tool will be useful for parsing this. Here is a simple way to do it: