This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
OK, those 2 datasets are very different. The data in the first post looks like standard JSON, however the data in the CSV looks like that has just been Cross-tabbed.
To answer the question you asked in the first post, you could do a for loop by way of a Batch Macro, however it is by far not the quickest method here. If you could guarantee that there was the same amount of sections in each record number, then a Multi-row formula would work, but possibly not the quickest and far from elegant.
As I indicated previously, splitting the Name on the point would then allow you to crosstab. You can then perform as many calcs as you would like.
In the attached, I have shown splitting from the first dataset (I manually added a value column), and also how I would deal with the data in the second dataset, however hopefully that's not what you're getting as it has duplication and errors in it.