Concatenate all data based on criteria - Microsoft Community 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