I have a spreadsheet that has client numbers. For each client number there are alpabet letters that are in different rows (see attached). What I want to do is move the letters up so they are in one row. Sometimes the letter or letters are in the same row but sometimes they are not. I am moving them manually right now but there are over a 1000 client numbers to do this for. Would a macro be able to do this? Thanks for any help you can provide.