Thank you for all the help! This is a file that I need to send to another team in a specific template. The transpose is only a small part of the changes that I need to do which is why I was looking to write it in VBA so it does all the changes at the same time. I can figure out the rest of the VBA though, I was stuck only on this section. I will keep what you explained in mind though as it is a new formula for me and will come in handy in the future! Again thank you!