Multilayered header_transposed to to the records

ksotirovska

Hello,

I am fairly new to Alteryx, and right not I am attempting to transform a table with multi-layered header. i.e. transforming structured table into a flat file.

Basically, the headers contain data value of the desired output. Below I am attaching both input and desired output data.

Can anyone help me with this?

So far, I have attempted with ARRANGE (and came up with nothing), and also isolating the header with DATA RECORDS and then TRANSPOSE and MULTI ROW and afterwards  concernating it with SUMMARIZE , but all I come up with is elaborate header and my data is still captured there. 

Thank you!

Input data

Desired output (just for record no. 1)

OllieClarke

Hi @ksotirovska I've attached a packaged workflow which does what you're after here:

The first browse tool has the data in this format (which I think is preferable): 

 

The second browse tool has the data in your requested format, but I don't believe that this final step is necessary

headers.yxzp