Make the first column be the header and second column be the value

[cl1818]

I'm new to Alteryx and I'm not sure how will make the first column be the header and the second column be the data

[alexnajm · Accepted solution]

Based on your description, the Crosstab tool is your best bet! You may have to do some clean up beforehand though (like remove blank/null rows)

[alexnajm]

Headers would be column 1, values would be column 2, and I’d just select concatenation as the aggregation method

[binuacs]

@cl1818 one way of doing this

[cl1818]

Thank you so much!

[cl1818]

Thankyou so much!

[cl1818]

Additional question, how to select the null field replace it and move the data up.

[alexnajm]

Without knowing your workflow, it’s hard to suggest something. I assume you are using the Crosstab tool, so make sure you have your grouping column(s) values across all rows so they aggregate properly