I have a AD data in a table. The data looks like this:
Users.Fleet Accounts Div.Financial Accounts Group.HeadOffice
the period (.) separates the Organsation units
It needs to be changed to look like this:
Fleet Accounts Div.Financial Accounts Group.HeadOffice.Users.
Is there way any to to...
I think you are looking at Reversing the words.
What is now
Users; Financial Payments Div; Financial Accounts Group; HeadOffice
you want to be
HeadOffice; Financial Accounts Group; Financial Payments Div; Users
Can you confirm please?