Turn header into regular row

[jcornale]

I want to turn a header row into a regular row. For example:

[jdunkerley79]

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

[danrh · Accepted solution]

Another option, using the Field Info tool:

[EmanueleE]

Hi @jcornale,

I had fun solving this problem without "Join" Tool.

result

generate rows

multi field

[Boneckrh19]

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?