Hello Everyone,
I am new to Alteryx and have been trying to create a report that used to be handled in Excel. I am struggling with creating a double header (like codes in the top row (row 3 for example) and their description in the following row (row 4)). The values would be in the corresponding columns. I have tried different methods in Alteryx and have not been satisfied with what I produced. I tried using 2 Crosstab tools to split the data, but I would like the Customers' Names and Customer ID headers to be at row 4. I also tied using just the Table tools, but the alignment of the codes and the descriptions was off. I am obviously not doing it right and would appreciate any assistance. I attached a copy of the sample Data and the Desired outcome. Thank you.
