How to use Multi-Row Formula across more than one field

Question

Hi

I would like to pull down data for more than one field

I have seen the helpful advice on how to use the Multi-Row Formula tool to accomplish pulling down data for one field; how do I pull data down for several fields without having to generate multiple Multi-Row Formula tools?

Thank you

DataNath · Answer

@Cen64 as standard, this isn't possible and requires some additional workarounds. One approach is to Transpose your data before using the grouping functionality in a Multi-Row formula and then re-Cross-tabbing. However, I saw on a similar request recently that @patrick_digan has actually created a Multi-Row-Field macro which combines the best features of both. Perhaps that'd be suitable for your requirement?

https://community.alteryx.com/t5/Public-Community-Gallery/Multi-Row-Field-Column-Macro-example/ta-p/879896