how to transform data

[Anonymous]

Hi, here is a excel data like this:

I want to transform it in power BI to make it like this:

do you have any ideas? Thank you.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...