I have a large spreadsheet listing requirements, one of the accompanying columns lists multiple tests associated with each requirement. I need to re-organize the table to be a list of tests with all the associated requirements in next column.
I've been trying to do this using formulas due to limited macro experience but any help/advice is welcome. Intermediary steps is ok too, just can't do this manual as my spreadsheet is over 3k requirements with 1k different tests. Uploaded sample xlsx, please help!