Transposing summerized row to a column

[vikula]

I'm new to alteryx  and before posting my issue, I looked as much as I could to see if there were any similar ones before and I couldn't find any. I'm trying to move data from Jason file to a tabular format.  Lot of examples in this forum helped me in getting to a point where I'm able to parse the Jason file and split the different levels of data into corresponding columns. Here is where I hit the road block.  I want to transpose summerized(higher level) rows into columns in the form of repeated values.

Convert this : 

JSON_Name6	JSON_Name7	JSON_Name9	JSON_Name10	JSON_ValueString
0	PROD_GRADES	0	CODE	Diesel
0	PROD_GRADES	0	PRICE	1.149
0	PROD_GRADES	0	CHANGEFLAG	SAME
0	PROD_GRADES	1	CODE	Super E5
0	PROD_GRADES	1	PRICE	1.329
0	PROD_GRADES	1	CHANGEFLAG	SAME
0	PROD_GRADES	2	CODE	Super E10
0	PROD_GRADES	2	PRICE	1.309
0	PROD_GRADES	2	CHANGEFLAG	SAME
0	UNIQUEID			60d394d5-7514-46b4-8d6f-b3539a982fc0
0	CODE
0	CURRENCY			EUR
0	VOLUMEUNIT			LITER
0	QUERYSURVEYDATE			2018-02-16 01:44:54
1	PROD_GRADES	0	CODE	Diesel
1	PROD_GRADES	0	PRICE	1.119
1	PROD_GRADES	0	CHANGEFLAG	SAME
1	PROD_GRADES	1	CODE	Super E10
1	PROD_GRADES	1	PRICE	1.279
1	PROD_GRADES	1	CHANGEFLAG	SAME
1	PROD_GRADES	2	CODE	Super E5
1	PROD_GRADES	2	PRICE	1.319
1	PROD_GRADES	2	CHANGEFLAG	SAME
1	UNIQUEID			2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad
1	CODE
1	CURRENCY			EUR
1	VOLUMEUNIT			LITER
1	QUERYSURVEYDATE			2018-02-16 01:44:54

To: 

UNIQUEID	CODE	CURRENCY	VOLUMEUNIT	QUERYSURVEYDATE	CODE	PRICE	CHANGEFLAG
60d394d5-7514-46b4-8d6f-b3539a982fc0		EUR	LITER	2018-02-16 01:44:54	Diesel	1.149	SAME
60d394d5-7514-46b4-8d6f-b3539a982fc0		EUR	LITER	2018-02-16 01:44:54	Super E5	1.329	SAME
60d394d5-7514-46b4-8d6f-b3539a982fc0		EUR	LITER	2018-02-16 01:44:54	Super E10	1.309	SAME
2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad		EUR	LITER	2018-02-16 01:44:54	Diesel	1.119	SAME
2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad		EUR	LITER	2018-02-16 01:44:54	Super E5	1.279	SAME
2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad		EUR	LITER	2018-02-16 01:44:54	Super E10	1.319	SAME

Thanks in advance!!

[BenMoss · Accepted solution]

I think your looking for the cross-tab tool but first I would split the data into two streams based on the header levels.

 Solution attached.

[vikula · Accepted solution]

That split and Join did it. Thank you for such a quick response.