In my limited knowledge I tried few things, like I used "Regex tool", "Multi-row tool", "Cross Tab" etc but nothing is working for me.
Can someone please help how I can learn and get the desired output?
Here is the input data screenshot: -
Desired Output: -
And this is what I was trying to do:
Please find the excel file (Input data and desired output) as attached :-
User | Count |
---|---|
104 | |
82 | |
70 | |
54 | |
40 |