I need help with using Cross tab function. Currently, I want to transform from following: NameValueA2A21A2A22A2A23A1A11A1A12A1A13 To this: A1A2A11A21A12A22A13A23 However, the use of cross tab tool is so confusing for me. I have attached the workflow with container in the area I need help. Thank you! selectField.yxmc

You may need another column to Group By so that the data doesn’t get concatenated - likely a Multi Row Formula will do it but maybe you can put in a Record ID tool earlier (I’m on my phone so can’t open the file, although I’m curious why it’s a .yxmc)

other than that, [Name] is your column header, [Value] is your value, and likely concatenation is your aggregation method

binu_acs

@hcho2 one way of doing this

Cross_Tab_31102024.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703