Transpose tool

Question

Hi.

I have this table.

GenderAvg_Age_FAvg_Age_MM [Null] 65.351715F 63.673591 [Null]

I would like to get this:

GenderAvg_AgeM65.351715F63.673591

I can i do that with transpose?

Please, help me.

Thank you

Marie

Qiu · Answer

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

1114-Candykobli.yxmd

CoG · Answer

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

2023-11-13_11-58_Age.yxmd

TimN · Answer

Does this help?

age.yxmd