As I am slowly working my way up to “Excel Guru” around the office, I have been asked formula questions and excel functions that I never even knew existed. I remember the sense of accomplishment I felt when I wrote my first nested if-then function (that worked), ran my first advanced filter and created my first macro, all without having to ask for help. I felt like I could do anything in excel! The day I learned how to create a macro that would run several advanced filters for me, at two keystrokes, I danced around the office!
One day my manager came to me with a large excel file. He had all of his fields separated out into highly specific, individual cells that spanned across many, many columns. He needed the data from several columns and rows to be combined and shown in one cell. So, I needed a way to merge together several cells. The standard Merge Cell Feature in excel is helpful, but limiting. I searched the internet for a few minutes before I found the Merge Cell Wizard. This feature allows you to merge cells row by row as well as column by column. What is great about the Merge Cells Wizard is that you can specify what separator to use: comma, tab, return, etc.
Needless to say, I was thrilled that I was able to complete the task. Using this plug-in saved hours, if not days worth of work. You can get the plug-in for a fee through www.ablebits.com, or search for a free download that will offer a 30 day trial. If it is a tool that you will utilize often, it is worth every penny!