Duplicate Units and GL Codes with different Tax Master Codes

[RMB33]

I am trying to create a 5 yr GL Code to Tax Master Code for the group. However, in 2021 the team changed the Tax Master Codes. I am having trouble creating the desired output. The challenges I am facing:

• Duplicated Unit #'s with many of the same GL Acct Code
• Duplicated GL Account codes on separate lines due to different Tax Master Codes
• Amounts for 2021 are on a separate line due to a different Tax Master Code

I am trying to create a unique line for each Unit by GL Code with the 2021 amounts presented on the same row.

Does anyone know if this is possible to do in Alteryx?  I have attached the Input and Desired Output workflow. 

[BS_THE_ANALYST · Accepted solution]

@RMB33 can you check if this is what you're looking for? 

[binu_acs]

@RMB33 One way of doing this

[RMB33]

@BS_THE_ANALYST  Thank you so much!  This works!!!

[RMB33]

Hi @binu_acs - @BS_THE_ANALYST posted solution with columns for New Master Codes as well.   THANK YOU BOTH!  Cheers.