transpose

[aditidhooria]

Hi everyone,

I have a column C1 for table sample table. I am trying to plot a table in which I need to use the fields as columns in my table and display count of fileds in respective positions. 

For example: I have a the following table:

Required Table

And the output should look like the following ie. E1, E2 and E3 have counts in their field values :

Output

Can anyone help ?

[ImkeF · Accepted solution]

That's actually a Pivot-operation: http://radacad.com/pivot-and-unpivot-with-power-bi