Merged Columns in Excel

Question

I am struggling with transforming some source data.  My data has double column headers with the top header merged across multiple columns.  How can I build a workflow that will transform and transpose this data to get it to look like my desired output.  I am struggling where to start with this.  New columns of data are added each quarter but my workflow needs to be able to determine which columns that Merged column header applies to.

Consensus Data2.xlsx

Emil_Kos · Answer

Hi @Ryan_Myers,

In order to make it work you need to remove the two first line from the data set:

As I have removed it because I believe in your original data set you don't have them.

Double Header.yxmd

Ryan_Myers · Answer

@Emil_Kos

appreciate your help.  can you send the workflow as a normal file.  You are working in a later version and i can't update the version in Notepad on those packaged workflows.

AngelosPachis · Answer

Hi @Ryan_Myers ,

Here is a workflow that will allow you to do it. If you want to focus more on a certain part then that would be whatever is inside the container box; this is where all the tricks happen to assign your column headers correctly

It's not an elegant solution by no means because the data was quite messy with some hidden columns as well that Alteryx always picks up. But moving forward maybe you can use this as a proof of concept for what you want to achieve, or tweak it so it works in your instance,

Regards,

Angelos

example.yxmd