If you are new to Excel, there is a great tool called “Flash Fill”, that allows you to fill in cells based on information in other columns, along with additional information typed in the column being flash filled. This video will show a quick demonstration: