title: PowerPivot transpose column headers on rows
body: <p>I have two datasources, one comes from an excel file i cannot change with this format</p>
  
  <pre><code>item | week 1 | week 2 | ...
  ITM01|   12   |    23  | ...
  </code></pre>
  
  <p>My second datasource comes from a query and looks like</p>
  
  <pre><code>item | Week | Value
  ITM01|  1   |   5
  ITM02|  2   |   10
  ...
  </code></pre>
  
  <p>I need to merge the two tables to have, hopefully, something like</p>
  
  <pre><code>item | Week | Value 1 | Value 2
  ITM01|  1   |   5     |   12
  ITM01|  2   |   10    |   23
  ...
  </code></pre>
  
  <p>I'd like to achieve this in powerpivot, considering that I cannot change the excel datasource, and i would like it to be updateable by using excels refresh button, which means, i think, that i should not create custom tables to handle the transposition, as that might ruin the refresh.</p>
  
  <p>I'm really lost on how to achieve this and some help would be much appreciated.</p>
  
  <p>I'd also add that i can change the second data source to look like the first one(weeks on columns), but while i might be able to connect the two tables, i would still not know how to achieve the desired output with weeks on rows.</p>
  
  <p>Thanks a lot for your time.</p>