Transpose tool.

[Candykobli]

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

[caltang · Accepted 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/

[Candykobli]

Why I didn't think about filter tool 😁. Thanks a lot!!!!. It works perfectly.