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 |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |