title: Power Query show json value
body: <p>Hello I am not much familiar with the Power query. I am trying to extract value from JSON file.</p>
  <p>JSON Data looks like this</p>
  <pre><code>{
    &quot;data&quot;: [
      {
        &quot;A&quot;: &quot;AT&quot;,
        &quot;B&quot;: [
          {
            &quot;C&quot;: &quot;CT&quot;,
            &quot;D&quot;: &quot;DT&quot;
          },
          {
            &quot;C&quot;: &quot;ET&quot;,
            &quot;D&quot;: &quot;FT&quot;
          }
        ],
        &quot;E&quot;: &quot;ET&quot;
      },
      {
        &quot;A&quot;: &quot;FT&quot;,
        &quot;B&quot;: [
          {
            &quot;C&quot;: &quot;GT&quot;,
            &quot;D&quot;: &quot;HT&quot;
          },
          {
            &quot;C&quot;: &quot;IT&quot;,
            &quot;D&quot;: &quot;JT&quot;
          }
        ],
        &quot;E&quot;: &quot;KT&quot;
      }
    ]
  }
  </code></pre>
  <p>In Power Query Editor This looks like this</p>
  <p><a href="https://i.stack.imgur.com/q0HDu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q0HDu.png" alt="ex 1" /></a></p>
  <p>What I am looking for is the way to show Value.B Column Data like this instead expending it to new row</p>
  <p><a href="https://i.stack.imgur.com/NC2mr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NC2mr.png" alt="ex 2" /></a></p>