Hello everyone,
I hope you are doing well !
I have a really important question,
Is there any way to do this in Alteryx ?
Thank you in advance.
@salimaelalouaji will you be able to add the same input excel file?
Hello, here it is.Thanks in advance.
@salimaelalouaji This kind of table would be a quick job in Excel if your data already looks good you can throw it into a pivot table
That's what I'm doing right now, but I really need it to be automated too because I do other manipulations after this step as well.
I'm not sure if you ever found an answer. I've accomplished this task in Alteryx, by creating separate tables for each line of header and then a 3rd table for the data. You can then union them and use the layout tool to combine them into a table.
@salimaelalouaji not exactly what you wanted ABc etc is in the header names, but take a look and let me know if this is close enough
