Do you want to attach a sample of the input and an expected output after the macro would be run? It would help in easily deciphering what is required, and provide a solution quickly.