I am trying to do a dynamic append fields but can't figure out how to do it in Alteryx:
The source looks like this:
The column field determines in which column the name row belongs to.
And desired results:
Challenge: The numbers of columns needed to be created is not known in advanced as the source varies - so I cannot put a certain amount of Append Fields or Text to Columns tools in advance.
How can I create the same result dynamically.
Thank you in advance for your help.