I mean merge becasue I am pulling a database that automatically fills every cell. For presentation purposes I don't want the excel sheet to be repetetive. the black and grey just show what to do the data looks like the attatched sheet. i want the first 3 columns to have the white parts with similar data merged row wise not column wise. So all the YO with a white background would be merged. and all the Notes. and all the numbers 712. then the next grey would be skipped and the GYT with a white background would be mergedAttachment 1514