Data Transpose

Question

Hello,

Am trying to Transpose headers that are in row format to column using the Cross Tab or Transpose tools but the information is not coming out as needed.  In the data sample provided, I need Alteryx to respect the order of the rows and transfer them to column format in the same order.  In Excel I am able to do, it just need to understand the tool that I need to use in Alteryx to perform the same process.

Thanks,

Maylen

New_Contract.xlsx

griffinwelsh · Accepted Answer

@verde0903 to retain the sort order append a recordID to the header and then remove it after the cross tab with a dynamic rename tool. Update workflow is attached.

verde0903 · Accepted Answer

Hi griffinwelsh

That's it.  It worked.  Thank you so much!  I'll mark it as solved.

Have a good day.

Maylen