Hey there, I am new to the forum and a proficient user of Excel, but by no means a professional. My issue is this...I am trying to transpose data that is in rows into columns. However, the one hitch is that my columns have been merged. I have created a couple hundred raw templates already and didn't think it would be an issue to move that data from horizontal to vertical, but it puts the information in separate cells instead of the large merged cell only. Is there a simple fix to this problem? Any suggestions would be appreciated, would save me a TON of time if I could find a solution to the problem. Thanks in advance if you help me out!