title: Using Power Query to extract data from nested arrays in JSON
body: <p>I'm relatively new to Power Query, but I'm pulling in this basic structure of JSON from a web api</p>
  <pre><code>{
      &quot;report&quot;: &quot;Cost History&quot;,
      &quot;dimensions&quot;: [
          {
              &quot;time&quot;: [
                  {
                      &quot;name&quot;: &quot;2019-11&quot;,
                      &quot;label&quot;: &quot;2019-11&quot;,
                      …
                  },
                  {
                      &quot;name&quot;: &quot;2019-12&quot;,
                      &quot;label&quot;: &quot;2019-12&quot;,
                      …
                  },
                  {
                      &quot;name&quot;: &quot;2020-01&quot;,
                      &quot;label&quot;: &quot;2020-01&quot;,
                      …
  
                  },
  
                  …
              ]
          },
          {
              &quot;Category&quot;: [
                  {
                      &quot;name&quot;: &quot;category1&quot;,
                      &quot;label&quot;: &quot;Category 1&quot;,
              …
                  },
                  {
                      &quot;name&quot;: &quot;category2&quot;,
                      &quot;label&quot;: &quot;Category 2&quot;,
              …
                  },
                  …
              ]
          }
      ],
      &quot;data&quot;: [
          [
              [
                  40419.6393798211
              ],
              [
                  191.44
              ],
              …
          ],
          [
              [
                  2299.652439184997
              ],
              [
                  0.0
              ],
              …
       ]
      ]
  }
  </code></pre>
  <p>I actually have 112 categories and 13 &quot;times&quot;.  I figured out how to do multiple queries to turn the times into column headers and the categories into row labels (I think).  But the data section is alluding me.  Because each item is a list within a list I'm not sure how to expand it all out.  Each object in the date array will have 112 numbers and there will be 13 objects.  If that all makes sense.</p>
  <p>So ultimately I want to make it look like</p>
  <pre><code>            2019-11 2019-20 2020-01 ...
  Category 1  40419   2299
  Category 2  191     0
  ...
  </code></pre>
  <p>First time asking a question on here, so hopefully this all makes sense and is clear.  Thanks in advance for any help!</p>