Data visualization help

[Sansudhi8]

Dear Team, 

Kindly look into the attached file. could you please help me arrange data as shown below. we can do it simply with the excel, but don't know how to do it with the Power BI. 

Thank you very much for your time.

Power BI File

Table which i need

[Sansudhi8 · Accepted solution]

Hi @Anonymous,

Sorry i couldn't find that option. Could you please give me more details. 

thank you. 

[Anonymous]

I'd try the Matrix visual, and on the settings for the visual under "Values" turn on "Show on Rows" 

[Sansudhi8 · Accepted solution]

Hi @Anonymous,

Sorry i couldn't find that option. Could you please give me more details. 

thank you. 

[Anonymous · Accepted solution]

[Sansudhi8]

Sorry got it 

thanks lot.