I want to have it so matching words in each column line up with each other on the same rows. This forum began to explain how to do it: How to align duplicates on the same rows in Excel it began to work with brettdj's comment in VBA, but I'm not sure how to make it work for my data. I have seven columns of data, and each have a different number of rows. The longest one is 2087 rows.
Thanks!