Parsing data to be side by side

[Deano478]

Hi all,

I've pulled data down from an API and just need some assistance with trying to parse it as I've tried multiple approaches and have had no luck.

The data in question which I have made ananoymous looks like so:

JSON_Name	JSON_ValueString
items.0.num	123456
items.0.name	TESTING COMPANY LIMITED
items.1.num	789101
items.1.name	TRIFECTA & TEST SERVICES LIMITED
items.2.num	121314
items.2.name	TEST ESTATES UNLIMITED COMPANY
items.3.num	151617
items.3.name	GLADYS COMPANY LIMITED

I need to get each row next to each so Items.0.num is next to items.0.name like so:

JSON_Name	Name	JSON_ValueString	Value
items.0.num	123456	items.0.name	TESTING COMPANY LIMITED
items.1.num	789101	items.1.name	TRIFECTA & TEST SERVICES LIMITED
items.2.num	121314	items.2.name	TEST ESTATES UNLIMITED COMPANY
items.3.num	151617	items.3.name	GLADYS COMPANY LIMITED

Any helps is much appreciated and my thanks in advance

[MilindG · Accepted solution]

@Deano478 Does this work for you?

[Deano478]

@MilindG that did the trick thank you. I've never used the make columns tool before so that's something new iv'e learned today

[MilindG]

@Deano478 Glad to help!!