I am trying to create a 3 yr GL Code to Tax Master Code for the group with a unique line for each Unit and GL Code. However, I am facing the following challenges:
- Duplicated GL Account Codes on separate line items bc certain years have GL codes are presented differently with missing leading or trailing spaces
- Units have all different # of characters for GL Codes for different units (for example, some have 4, some of 6, others have 8)
I looked into RegEx, fuzzymatch tools but wondering if anyone has seen this before and have a solution. I used the unique tool as well but because of missing leading zeros and different # of characters in account codes, I am having difficulties coming up with solution.
