I need to know if there is a macro or script I can run to automate this process. Thanks for helping!

Any help would be greatly appreciated! I have more than one spreadsheet to perform this on.