title: How to create a third sheet from shared data in two other sheets?
body: <p>I am trying to use two sheets in excel to create a third sheet.</p>
  <p>SHEET1 contains AccsessLevels, an AccessLevel can contain any number of Zones. SHEET2 contains the Zones, a Zone can contain any number of Items.
  RESULT_SHEET needs to have all of the AccessLevels from SHEET1, but needs to get the Items from each matching Zone entry in SHEET2.</p>
  <p>I have tried Power Query, but wasn't able to get it to perform this task. I have a basic knowledge of VBA, but this is above my skill level.</p>
  <pre><code>SHEET1
  | AccessLevels | Z1    | Z2    | Z3    |
  | ------------ | ----- | ----- | ----- |
  | AccessLevel1 | ZoneA | ZoneB | ZoneC |
  | AccessLevel2 | ZoneA | ZoneC |       |
  | AccessLevel3 | ZoneB |       |       |
  | AccessLevel4 | ZoneA | ZoneD |       |
  
  SHEET2
  | Zones | I1    | I2    | I3    |
  | ----- | ----- | ----- | ----- |
  | ZoneA | ItemA | ItemB |       |
  | ZoneB | ItemB | ItemC |       |
  | ZoneC | ItemA | ItemD | ItemF |
  | ZoneD | ItemE |       |       |
  
  RESULT_SHEET
  | AccessLevels | I1    | I2    | I3    | I4    | I5    | I6    |
  | ------------ | ----- | ----- | ----- | ----- | ----- | ----- |
  | AccessLevel1 | ItemA | ItemB | ItemC | ItemD | ItemF |       |
  | AccessLevel2 | ItemA | ItemB |       | ItemD | ItemF |       |
  | AccessLevel3 |       | ItemB | ItemC |       |       |       |
  | AccessLevel4 | ItemA | ItemB |       |       |       | ItemE |
  </code></pre>