Combining and formatting data

[pet01612]

Hi all, the NA, SA, and Managers workbooks attached are the data I am sourcing and the Output workbook is the solution. Any help on the workflow would be appreciated! 

[Qiu · Accepted solution]

@pet01612 

Made something and hoping I get you right.

Note that the input data schema matters here.

[pet01612]

Thank you, Qiu!

[Qiu]

@pet01612 
Glad to help and thank you for the accept mark. 😁