This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think something went wrong with the filter tool and action tool in your macro.
You can literally just use the macro from my last post in your workflow (as attached to this post)
One key thing to note: In the last version of the workflow and macro that I posted, I moved the Transpose tool out of the macro and into the workflow. That means that the input data structure of the macro has changed (it's a transposed version of the input file grouped to ID), so the macro input has to be updated to this format.
Because you're choosing the input file as a macro input, this is the wrong format, which is why the rest of the macro doesn't work.
If you have any problems importing and running the attached, give me a shout.