How to Pair and Pivot JSON Key-Value Pairs Using Transpose and Cross Tab in Alteryx?

[AKPWZ]

I have a dataset parsed from JSON in the following format:

Parse JSON
JSON_Name	JSON_ValueString	index
results.0.values.0.name	email	1
results.0.values.0.value	sigirence@gmail.com	1
results.0.values.1.name	firstname	1
results.0.values.1.value	Sigires	1
results.0.values.2.name	lastname	1
results.0.values.2.value	Ese Since	1
results.0.values.3.name	country	1
results.0.values.3.value	CO	1
results.0.values.4.name	tell_us_about_yourself	1
results.0.values.4.value	Student	1
results.0.values.5.name	sign_in_agree_to_t_c	1
results.0.values.5.value	TRUE	1
results.1.values.0.name	email	2
results.1.values.0.value	ismaro10@gmail.com	2
results.1.values.1.name	firstname	2
results.1.values.1.value	Ismael	2
results.1.values.2.name	lastname	2
results.1.values.2.value	Cipriani	2
results.1.values.3.name	country	2
results.1.values.3.value	PE	2
results.1.values.4.name	tell_us_about_yourself	2
results.1.values.4.value	leader	2
results.1.values.5.name	tell_us_about_yourself	2
results.1.values.5.value	Educator	2
results.1.values.6.name	sign_in_agree_to_t_c	2
results.1.values.6.value	TRUE	2

I need to transform it into this expected format:

Expected Result
email	firstname	lastname	country	tell_us_about_yourself	sign_in_agree_to_t_c
sigirence@gmail.com	Sigires	Ese Since	CO	Student	TRUE
ismaro10@gmail.com	Ismael	Cipriani	PE	leader	TRUE
ismaro10@gmail.com	Ismael	Cipriani	PE	Educator	TRUE

I tried using the Transpose and Cross Tab tools, but I am struggling to pair the .name and .value entries correctly. Could someone guide me on how to achieve this transformation step by step?

Attaching excel file.

[alexnajm · Accepted solution]

Here's a start for you:

[AKPWZ]

Thank you so much @alexnajm