Can someone recommend a good e-learning site to learn to build Alteryx Macros
Here you go, see attached. The Summarize tool gets you most of the way there. Hope that helps.
I seem to have answered a different question, seems odd. But to answer your question on Macros, there are some very good Knowledge Base articles on Macros.
Standard Macros:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Standard-Macros/ta-p/488149
Batch Macros:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165
Iterative Macros:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Iterative-Macros/ta-p/488173