Hi
I have this table:
Gender | Avg-Age_F | Avg_Age_M |
M | [Null] | 65.351715 |
F | 63.673591 | [Null] |
I would like to get this table:
Gender | Avg_Age |
M | 65.351715 |
F | 63.673591 |
How can I do that with the transpose tool? or maybe in another way?
Thank you very
Marie
Solved! Go to Solution.
Like so:
If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!
Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/
Why I didn't think about filter tool 😁. Thanks a lot!!!!. It works perfectly.