listing two columns under one sub column

[Anonymous]

For a table like below

Name	Physics	Maths
Vikas	88	90
Aakash	85	97
Ravi	89	91

I want Both Physics and Math to be under one column as “ Subject” as sub column. How can it be done?

[RajatJaiswal]

Use unpivot feature 

= Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Attribute", "Value")

[Anonymous]

Hi Rajat , somehwat like this:

 

 Is this possible?

[RajatJaiswal]

@Anonymous

If I understand correctly after reviewing your picture. I don't think it is possible. As it is columnar data so column physics & Maths should be different but if you want to show a report in power BI then we can think of it. Please, share what exactly you need and is it report view or data source table.

[Anonymous]

yes if it is possible to show report in powerBI and aslo if  it is  possible to get that as view in tabular form in report? as in visualization?

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Yes, you can achieve this by adding a new table like below. And other parts are like @RajatJaiswal's solution. Please check out the demo in the attachment.

Class                                                                   Course

Subject	Physics
Subject	Maths

Best Regards,

Dale