I want to turn a header row into a regular row. For example:
Another option, using the Field Info tool:
Easiest way I can think of is to use a Multi Field Formula to get Name and store as value remembering to change field type and to not create new fields.
Then union onto data.
Sample attached
Hi @jcornale,
I had fun solving this problem without "Join" Tool.
result
generate rows
multi field
Danrh, my version of Alteryx is too old to open your file; could you tell me what you put in Record ID and Cross Tab?
