Pass from table A to table B

[lmfernandez]

Hello, after import an excel document to Power Bi, in Transform option, I have a table like A but I need a table like B.

How can I do that?

I need to group that columns like the picture I show.

Thank you for your help.

[amitchandak · Accepted solution]

@lmfernandez , a very similar case has been discussed here unpivot twice. check if that can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/