I have a CSV of Confluence permission values for each Space that’s thousands of lines long. I need to

1. Find each row containing grpID ‘XYZ’ for a given Space
2. Check for Space rows that do not also contain a permission row for grpID ‘ABC’
3. Duplicate that row and change grpID to ‘ABC’ so that for each row with an XYZ permission, there’s now an ABC permission and an XYZ permission for each Space

Any guidance will be appreciated. I’m usually keen to dig in and figure this out for myself, but I’m under the gun.

I’ve tried to record keystrokes and save it as a script, but it’s only copying the value of the cell id (e.g. (“A58”)) instead of finding a cell with a value of ‘XYZ’.