Saw a post about how to create a UDF to concatenate randomly selected cells. It does everything I want BUT the data needs to be Vertical for the UDF to work. My data that needs to be concatenated is all horizontal. Any solutions out there on how to change the code?
Here's a link to the original post.