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
