how to transform data

Question

Hi, here is a excel data like this:&nbsp;I want to transform it in power BI to make it like this:&nbsp;do you have any ideas? Thank you.&nbsp;&nbsp;

lbendlin · Answer

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-p/963216

Forum Discussion