Data Preparation 2 inputs and output to consolidate Excel in the same worksheet name

[sgwong]

I would like to seek advice transform 2 different format input source and consolidate output by grouping name/last co & split by sub region.

As per attach for 2 inputs and 1 output format to Excel.

[Chaoued]

the output requirement isn't clear enough but, I'm building a workflow it might help you just adjust it to your need

[sgwong]

Thank you for your input.

I wiuld like my output format table structure as below:

Name / Last CO        All Central   Genting Highland     etc.

Name A                   

    Last CO  A1 

    Last CO  A2

Name   B                  

    Last CO  B1 

    Last CO  B2

[sgwong]

How to remove those receord in red in work document for workflow attacged.

[sgwong · Accepted solution]

As per attach for workflow  to get outpur result as expected.