Nested Headers-Complex Transformations

[Huchida]

I want to analyze the data file with nested headers as attached.

Please teach me the workflow to make output image from row data.

Best regards

[Qiu]

@Huchida 

Hope this works for you.

[Huchida]

@Qiu 
Thank you for your response.

In your workflow, the output is inconsistent with my output image.

In detail,

・In raw data, Team A to C work for only House Segment.

・And, Team D to F work for only Office Segment.

・House Segment and Office Segment is the part of Construction Segment

＝＞exp: Team A work for House Segment and the cost breakdown is COGS material 453, COGS labor 282 ・・・, SG&A utility 563 and SG&A other 109.

I used to analyze with Excel Power Query, and with Power Query I can use transformation ( ≠ Pivot and Unpivot, = change layout into exact opposite). However, with Alteryx I cannot change layout like that......

[Qiu]

@Huchida 
Sorry about that.
Let me try to fix that.

[Qiu · Accepted solution]

@Huchida 
How about this one.

[Huchida]

@Qiu 

Thanks a lot!!

[Qiu]

@Huchida 
It is really a brutal force approach and certainly requires some modification for your really bussiness application.
thank you for the accept mark😁