Hi,
I am trying to shift the rows into columns. I know that I should use transformation tool, I tried few but it did not work. So I want some help plz.
Thank you in advance,
I have this
and I want this
Solved! Go to Solution.
Hey @AmAm,
You need to have name as a key column and the rest as data columns. Like so (I've attached an example workflow):
The key columns will remain the same and the data columns will pivot round them.
@IraWatt Thanks man!!
No worries at all ! :)
User | Count |
---|---|
108 | |
84 | |
76 | |
54 | |
40 |