Show column count for each user

[Dante79]

Hi, I'm very new to Power BI.

I'm trying to create a Matrix that extracts the below Excel data and outputs to the following table, so I can create a few visual graphs from the 2nd table.

Would really appreciate someone to guide me please as I'm a beginner. Thanks in advance !

[Anonymous]

Hi @Dante79,

Please follow this link. Hoping you wil get solution of your problem. 

https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473

If any concern revert me back.

Best Regards,

Ravi

[Dante79]

Thanks for your prompt reply !

I tried some of the steps in the link and managed to merge the columns into one but still can't figure out how to achieve the output table view that I desired.

[Anonymous · Accepted solution]

Hi @Dante79,

I hope instead of merge, Unpivoting the column would helped you.

Best Regards,

Ravi

[Dante79]

Thanks Ravi !

You've been a great help ! Really appreciate the gesture to do a video call to teach me step-by-step too. Two thumbs up !

[Anonymous]

This i have done by taking sample data you provide.