Unmerge Columns to set up data set

Question

Hi community,

I have attached the problem to be solved. I need to unmerge the headers "Turnover", "EBIT" and so on in order to have two separate columns in the end. Alteryx puts the merged columns into just one cell. I tried unpivoting, but that didn't really work well.

Help would be much appreciated.

Thank you.

Alteryx Case.xlsx

Jonathan-Sherman · Accepted Answer

Hi @Merger123,

This was a tricky one! Issue was there are two header lines which need to be combined one of which isn't fully completed (Turnover / EBIT) as you said.

However got there eventually:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan