Concatenate all data based on criteria I am trying to clean up a converted PDF document in Excel. I need to concatenate several cells of data. The number of cells that I need to combine in-between items varies throughout my file (2-5 different cells of data in-between item changes). Here is what my data looks like.
How do I concatenate all the rows in column one into ONE cell in column two? I'm using a long list of email addresses and need to copy/paste the entire list into a single email. Thanks for any help!
