I have a table that looks like Original Table in the attached spreadsheet.
As you can see, instead of one row per account, there is a range per group.
Each Account can belong to more than one group. Basically they are nested.
I think I need to transform it into the Desired Outcome.
I assume I will need some type of loop. Can anyone suggest where I might start please.
Sample File.xlsx (16.5 KB)