• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Transposing a table

jutu

Member
Hi. I am quite new to power bi and not sure how to go about it. I have account mgrs in the first row and then their corresponding targets from Oct to Mar. How could I transpose it so that there is one column for each account mgr? I tried transposing it. It does the job but no column for the corresponding month names, just the values for each mgr. Since there are only 6 months (7 rows with the heading), if the only way is to create another column with each month it's ok but not sure how to create another column with specific values for each row. Thank you in advanced
 

Attachments

  • sample.xlsx
    17.1 KB · Views: 2
Select column account manager, then from the context menu choose "unpivot other columns" (right mouse click).
 
Like so?:
80703

It does the job but no column for the corresponding month names
Demote the headers first, then transpose, then promote 1st row to headers.
 

Attachments

  • Chandoo48749sample.xlsx
    24.7 KB · Views: 5
Perfect. I was doing that but should have chosen "Use headers as first row", then "Use first row as headers". Many thanks
 
Back
Top