Hello,
I am trying to transpose multiple columns into rows.
Here is my data:
I want the result to be :
Thank you so much for your help.
Find in attachement a solution to this issue.
Let me know if there is an issue with this solution.
@Krakan It worked ?
It works, thanks a lot!
Hi,
Unfortunately it doesn't work beacuse the final result in your workflow is:
I need below result:
Do you know how can I change it?
Thank you.
Could you please take a look for my reply?
Thank you.
Hi @Krakan
All my excuses for this mistake !
You can find in attachement the version of workflow which generate correct output.
Let me know if there is still any issue.
Hi @Emmanuel_G
Unfortunately this solution cannot be adjusted to my dataset because in my original dataset I have more columns/rows.
Sorry for the confusion I just wanted to know universal method.
Please find my original dataset (more columns than rows and net new money/loans instead measure1/measure2).
Below desired output.
Thanks in advance.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |