How to: Unstack Data

[ahadi063]

Hi everyone! 

I am new to BI and was wondering if someone would be kind enough to help with a problem I am facing. 

Please see attached the output format that I am getting from a reporting tool and I need it to transform it as how it is seen in "Desired look" tab. 

This is the following transformation that I need:

1. Be able to put all the variables to headers and transform it as columns. 

2. Be able to delete the all the rows associated with "Weekly Summary". 

If anyone can help that would be great!

[v-chuncz-msft · Accepted solution]

@ahadi063,

You may directly Connect to data in Power BI Desktop and transform the data in The Query Editor.