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:

Gender	Avg_Age
M	65.351715
F	63.673591

I can i do that with transpose?

Please, help me. 

Thank you

Marie

[TimN]

Does this help?

[CoG]

Simple Formula should suffice as well since one field or the other should always be Null

[Qiu]

@Candykobli 
I would further add 2 more tools to the flow of @TimN to get the exact format as you specified.