I have a template we use to determine how to filter HR data. The business wants to be able to dynamically exclude certain companies based on a value called MRC.
Please find attached the template we are using. Column J is the one I would like to parse out and then based on how many new fields get created, a new row would be created that includes all of the other data on the same row but would include one of the MRC values. So if there are 3 values in column J 3 new rows would be created with all of the other info. if there are 2 - two new rows.. etc.
I assume this is possible with some type of dynamic formula tool or another method?
